/build/static/layout/Breadcrumb_cap_w.png

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

Thanks
Answer Summary:
0 Comments   [ + ] Show comments

Comments


Answer Chosen by the Author

1
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")

Answered 02/19/2016 by: chucksteel
Red Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
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