/build/static/layout/Breadcrumb_cap_w.png

total number of tickets submitted by user/submitter

I would greatly appreciate it if you can help me with an SQL report that can list all submitters in order of the highest to lowest number of tickets submitted.

Thank you in advance.


1 Comment   [ + ] Show comment
  • Thank you five. I’ll give it a go. - aoh 6 years ago

Answers (1)

Posted by: five. 6 years ago
Second Degree Green Belt
0
I believe this old answer would suffice.

Just comment out the where date line and it'll show them all and add an order by at the end, like so:
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
ORDER BY COUNT(*) DESC

Don't be a Stranger!

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

Sign up! or login

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