/build/static/layout/Breadcrumb_cap_w.png

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.
Posted by: getElementById 9 years ago
Third Degree Blue Belt
0
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.
 
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