Queue-Task report

[Wendy Howerton]

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.

[Chitra Kondorambathi]

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 ;

[Wendy Howerton]

Thank you so much Chitra - that worked perfectly!!