/bundles/itninjaweb/img/Breadcrumb_cap_w.png
I need help with a report broken down by all support queues and owners for each queue showing all tickets opened and how long they have been open from creation date. 

Thank you for your time
0 Comments   [ - ] Hide Comments

Comments

Please log in to comment

Answer this question or Comment on this question for clarity

Answers

0
How is this:
SELECT HD_QUEUE.NAME, OWNER.FULL_NAME, COUNT(HD_TICKET.ID) AS "Open Tickets"
FROM ORG1.HD_TICKET
JOIN USER OWNER on OWNER.ID = HD_TICKET.OWNER_ID
JOIN HD_QUEUE on HD_QUEUE.ID = HD_TICKET.HD_QUEUE_ID
JOIN HD_STATUS on HD_STATUS.ID = HD_TICKET.HD_STATUS_ID
WHERE HD_STATUS.STATE != "closed"
GROUP BY HD_QUEUE.ID, OWNER.ID
ORDER BY HD_QUEUE.NAME, OWNER.FULL_NAME
This will only return ticket counts for owners that have an open ticket.

Answered 04/17/2018 by: chucksteel
Red Belt

Please log in to comment
0
Here is a version of Chuck's report that will show all tickets and the opened time (in days):
SELECT HD_QUEUE.NAME, OWNER.FULL_NAME, HD_TICKET.ID, HD_TICKET.TITLE,
  DATEDIFF(NOW(),HD_TICKET.CREATED) AS 'Days Opened'
FROM ORG1.HD_TICKET
JOIN USER OWNER on OWNER.ID = HD_TICKET.OWNER_ID
JOIN HD_QUEUE on HD_QUEUE.ID = HD_TICKET.HD_QUEUE_ID
JOIN HD_STATUS on HD_STATUS.ID = HD_TICKET.HD_STATUS_ID
WHERE HD_STATUS.STATE != "closed"
ORDER BY HD_QUEUE.NAME, OWNER.FULL_NAME
Answered 04/26/2018 by: JasonEgg
Red Belt

Please log in to comment