Report top ticket submitters
I am looking to create a report that will list all users that have submitted a service desk ticket and the # of tickets each has submitted within the previous 30 days.
Thanks.
0 Comments
[ + ] Show comments
Answers (1)
Answer Summary:
Thank you, that worked like a charm and is exactly what I was wanting.
Thank you, that worked like a charm and is exactly what I was wanting.
Please log in to answer
Posted by:
getElementById
9 years ago
I didn't check for a built-in report but here is some simple SQL that should get the results your looking for.
SELECT U.FULL_NAME AS 'Full Name', U.USER_NAME AS 'Username', COUNT(*) AS 'Number of Tickets'
FROM HD_TICKET T LEFT JOIN USER U ON T.SUBMITTER_ID = U.ID
WHERE DATE_SUB(CURDATE(), INTERVAL 30 DAY) <= T.CREATED
GROUP BY U.USER_NAME
[EDIT] - I checked and I don't see a built-in report for tickets that sorts by submitter. There are open/closed reports by owner which would be the tech working on it.
The SQL above will pull all non-archived tickets, closed or opened. If you want to only include open ticket or closed tickets you would want to join the HD_STATUS table and look for HD_STATUS.STATE = 'closed' or HD_STATUS.STATE rlike 'opened|stalled' depending on the results you want.
