KACE Product Support Question
Report shows closed tickets
07/06/2016 446 views
I would like to create a report that shows the total amount of closed for each month for the past year, for example.
we currently run this script to show the amount of tickets closed for the previous day
SELECT T.ID, T.CREATED, T.TIME_CLOSED, OWNER.FULL_NAME as "Owner",
CLOSER.FULL_NAME as "Closer"
FROM ORG1.HD_TICKET T
LEFT JOIN HD_TICKET_CHANGE CLOSED ON CLOSED.HD_TICKET_ID = T.ID and CLOSED.DESCRIPTION like '%Changed ticket Status from%to "Closed"%'
LEFT JOIN USER OWNER ON OWNER.ID = T.OWNER_ID
LEFT JOIN USER CLOSER ON CLOSER.ID = CLOSED.USER_ID
WHERE T.TIME_CLOSED > DATE_SUB(NOW(), INTERVAL 24 HOUR)
AND (CLOSER.USER_NAME = "jwinn" or CLOSER.USER_NAME = "twinn")
Answer Chosen by the Author
Please log in to answer
Thank you very much, that script works great! Is there a way to only show closed tickets from 2 specified users?
Answered 07/07/2016 by: joshuaer