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

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
Highlighted

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

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

Highlighted

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

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!