I would like to run a monthly report that shows which client user had the most tickets per a request type.
12.2.0 - Build #12.2.0.9011
For what its worth you can upvote that existing feature request here
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.
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 don d.CLIENT_ID = a.CLIENT_ID inner join WebHelpDesk.dbo.status_type eon e.STATUS_TYPE_ID = a.STATUS_TYPE_IDwhere a.DELETED <> 1 and a.PROBLEM_TYPE_ID <> 11and a.REPORT_DATE >= getdate()-90group by d.FIRST_NAME +' '+ d.LAST_NAMEorder by count(*) desc
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
