/build/static/layout/Breadcrumb_cap_w.png

Service Desk Queues breakdown by owner

We currently have multiple service desk queues. I was wondering if any one has sql query that could break down the queues more down by person per queue.  The default templates are an combination of all.

OWNER_NAME specifies who closed the ticket

This query breaks it down by Queue

SELECT HD_QUEUE.NAME, count(HD_TICKET.ID) FROM ORG1.HD_TICKET
JOIN HD_QUEUE on HD_QUEUE.ID = HD_TICKET.HD_QUEUE_ID
WHERE CREATED > DATE_SUB(NOW(), INTERVAL 30 DAY)
GROUP BY HD_QUEUE_ID


0 Comments   [ + ] Show comments

Answers (1)

Answer Summary:
Posted by: grayematter 4 years ago
5th Degree Black Belt
0

Top Answer

Are you asking for ticket counts by queue, then by owner?  If so, this query should work for you.

SELECT HD_QUEUE.NAME, USER.USER_NAME, count(HD_TICKET.ID) 
FROM ORG1.HD_TICKET
JOIN HD_QUEUE on HD_QUEUE.ID = HD_TICKET.HD_QUEUE_ID
INNER JOIN USER ON USER.ID = HD_TICKET.OWNER_ID
WHERE HD_TICKET.CREATED > DATE_SUB(NOW(), INTERVAL 30 DAY)
GROUP BY HD_QUEUE_ID, USER.USER_NAME
ORDER BY HD_QUEUE_ID, USER.USER_NAME

Comments:
  • Yea great that's what I was looking for! - tsbb2015 4 years ago
 
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