Tickets Closed Report by Specific Users
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
Thanks
Thanks
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
8 years ago
Top 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",
CLOSED.TIMESTAMP, CLOSED.DESCRIPTION,
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")
Comments:
-
Thanks so helpful. - witylernn 8 years ago