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