/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: chucksteel 6 years ago
Red Belt
0
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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ