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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share