cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1016
Views
0
Helpful
2
Replies

Queue-Task report

Wendy Howerton
Level 1
Level 1

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.

2 Replies 2

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
Level 1
Level 1

Thank you so much Chitra - that worked perfectly!!

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: