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.

Answer Summary:
Thank you, that worked like a charm and is exactly what I was wanting.
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

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.
Answered 01/22/2015 by: getElementById
Second Degree Blue Belt

Please log in to comment
Answer this question or Comment on this question for clarity