/build/static/layout/Breadcrumb_cap_w.png

Report of Ticket Ownership Escalations by Owner

Here is a report of ownership escalations by owners. This will capture escalation and routing data not necessarily captured in a simple "tickets closed" etc report.

SELECT USER_NAME,
COUNT(USER_ID) as TOTAL
FROM `ORG1`.`HD_TICKET_CHANGE`
LEFT JOIN USER UPDATER ON UPDATER.ID = USER_ID
LEFT JOIN HD_TICKET OTICK ON OTICK.ID = HD_TICKET_ID
WHERE USER_ID != 0
AND DESCRIPTION LIKE '%Changed ticket Owner from "%'
AND DESCRIPTION NOT LIKE '%Changed ticket Queue from "%'
AND OTICK.HD_QUEUE_ID = 1 /*1 is the default queue...*/
AND ((TIMESTAMP(TIMESTAMP) <= NOW() AND TIMESTAMP(TIMESTAMP) > DATE_SUB(NOW(),INTERVAL 1 MONTH))) /*can change interval*/
AND USER_NAME NOT LIKE '%ADD FILTERS FOR ERRONEOUS RESULTS%'
GROUP BY USER_ID ORDER BY TOTAL DESC LIMIT 30;


Comments

This post is locked
 
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