/build/static/layout/Breadcrumb_cap_w.png

K1000 Ticket Interactions Report

This report is very simple yet allows you to see exactly how much information owners are adding to tickets and if you have a third party helpdesk using the kbox, this will let you track every interaction with the help desk for proper billing of the third party support.

SELECT USER_NAME,
COUNT(USER_ID) as TOTAL
FROM `ORG1`.`HD_TICKET_CHANGE`
LEFT JOIN USER UPDATER ON UPDATER.ID = USER_ID
WHERE USER_ID != 0

/*timeframe*/
AND (TIMESTAMP LIKE "2013-09%" OR TIMESTAMP LIKE "2013-10%" OR TIMESTAMP LIKE "2013-11%")

/*internal filtering - substitute what is appropriate based off of your results and what you want to see*/

AND USER_ID != 4538
AND USER_NAME NOT LIKE "%ems_p%"
AND USER_NAME NOT LIKE "%auto-%"

/*limit 30 to just see our owners - not everyones interaction tallies*/
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