/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


Report top ticket submitters

01/22/2015 1675 views

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.
0 Comments   [ + ] Show comments

Comments


All 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
Third Degree Blue Belt

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:

Share

 
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