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.
1 of 1 people found this helpful
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