cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

Most Tickets per user monthly report.

Jump to solution

I would like to run a monthly report that shows which client user had the most tickets per a request type.

Web Help Desk Version:

12.2.0 - Build #12.2.0.9011

Tags (2)
0 Kudos
1 Solution
Level 14

For what its worth you can upvote that existing feature request here

View solution in original post

0 Kudos
3 Replies
Level 9

MSSQL statement to get the top "users" for the past 90 days and their ticket totals.

select d.FIRST_NAME +' '+ d.LAST_NAME as ClientName, count(a.JOB_TICKET_ID)

from webhelpdesk.dbo.job_ticket a inner join webhelpdesk.dbo.client d

on d.CLIENT_ID = a.CLIENT_ID inner join WebHelpDesk.dbo.status_type e

on e.STATUS_TYPE_ID = a.STATUS_TYPE_ID

where a.DELETED <> 1 and a.PROBLEM_TYPE_ID <> 11

and a.REPORT_DATE >= getdate()-90

group by d.FIRST_NAME +' '+ d.LAST_NAME

order by count(*) desc

Level 14

For what its worth you can upvote that existing feature request here

View solution in original post

0 Kudos
Level 12

I've been down this road before.  Per SW support they do not support client reporting.  I to would love to have a report that shows my heavy hitters.

0 Kudos