KACE Product Support Question
Tickets Closed Report by Specific Users
02/18/2016 517 views
Hi, I know how to create a report of tickets closed in the last 24 hours the only thing I am having trouble with is having the report only show 2 certain users on it
Answer Chosen by the Author
Please log in to answer
This query uses the HD_TICKET_CHANGE table to find tickets where the status was changed to "Closed" by specific users:
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 1 DAY)
AND (CLOSER.USER_NAME = "user1" or CLOSER.USER_NAME = "user2")
Answered 02/19/2016 by: chucksteel