cancel
Showing results for 
Search instead for 
Did you mean: 

OpsCenter query to get total SLPs still running/queued up in job queue

Monteroman
Level 2

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

2 REPLIES 2

watsons
Level 6

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.. 

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!