/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


total number of tickets submitted by user/submitter

01/09/2018 499 views

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

Comments

  • Thank you five. I’ll give it a go.

All Answers

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

Answered 01/09/2018 by: five.
Second Degree Green 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

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