Find all you need to begin your THWACK journey, including documentation, missions, blogs, community groups, events, and media.
Find the best place to learn and ask questions about your SolarWinds products.
Find downloadable files and templates other users have built and found useful to share with others.
Create individual user accounts for your team, manage your licenses, download your SolarWinds software, create and track support tickets, and more.
A one-stop-shop for world-class training for SolarWinds products through on-demand videos, and instructor-led classes. All SolarWinds Academy content is included with every software purchase.
Get help when you need it from a world-class support team, available to assist with technical product issues 24 hours a day, seven days a week, 365 days a year.
Accelerate SolarWinds Partners’ ability to drive digital and IT transformation for customers with powerful tools, resources, and increased profit potential.
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
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.
For what its worth you can upvote that existing feature request here
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
