Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

Queue-Task report

Queue-Task report

Hi - does anyone have SQL to run a report that will show the service, the queue and the tasks for that service?  I can get the service and tasks, but not the queue.

Everyone's tags (1)
2 REPLIES

Queue-Task report

select  b.Name,DEFAULTPERFORMEREXPRESSION FROM DEFSERVICE a,DEFTASK b,DEFPROJECT c
 WHERE  a.AREAID NOT IN (1,2,3,4,5,20)
 AND a.serviceid = 2782
 AND a.serviceid = c.OwnerInstID
 AND c.OwnerObjectID = 13
 AND b.projectID = c.ProjectID
 order by a.name , b.childlevel ;

New Member

Queue-Task report

Thank you so much Chitra - that worked perfectly!!

449
Views
0
Helpful
2
Replies
CreatePlease login to create content