report or export catagories listed in Service Desk Queues
hello, Has anyone with SQl knowledge know how to get an export of all the items listed in Catagories of a service desk queue?
Thanks
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
chucksteel
6 years ago
Here you go:
SELECT C.NAME, Q.NAME
FROM ORG1.HD_CATEGORY C
JOIN HD_QUEUE Q on Q.ID = C.HD_QUEUE_ID
ORDER BY Q.NAME, C.NAME
Comments:
-
WOW, great work a treat. Many Thanks however another quick question if i have multiple queues where would i select the name of the queue in the syntax? - markc0 6 years ago
-
You need to add a where clause:
SELECT C.NAME, Q.NAME
FROM ORG1.HD_CATEGORY C
JOIN HD_QUEUE Q on Q.ID = C.HD_QUEUE_ID
WHERE Q.NAME = "My Queue"
ORDER BY Q.NAME, C.NAME - chucksteel 6 years ago