02-15-2017 10:08 AM
Hi!
I'm trying to build a custom report to produce the same results as what an "nbstlultil report" and "nbstlutil stlilist -U -image_incomplete".
Would anyone be able to provide me with the SQL query for this? I've been looking through the schema PDF, but I haven't gotten very far.
Thanks all for any help!!
Paul
02-16-2017 08:34 PM
Always provide with the NBU version because tables could be different in schema.
I have one simple query to extract the incomplete SLP image itself.
select b.id from domain_SLPImage a, domain_Image b where a.id = b.id and a.StorageServiceState not in (0, 3, 9, 10)
Incomplete, for me, means either IN_PROCESS or NOT_STARTED. As in lookup_SLPState table, that translates to values not equal to 0, 3, 9, 10.
With this, you should be able to work out the output as in nbstlutil, "report" by displaying the column sizeOfImageInKbyte , "image_incomplete" by joining it with the column "name" of lookup_SLPState.
Hope that helps..
02-17-2017 11:03 AM
Watsons,
Sorry for not relaying the version, but it was 7.6.1. The query you provided was exactly what I was looking for. Thank you much!