Find the Number of Tickets Handled by Your Helpdesk Agents
Report on the number of tickets that were handled by an agent per month and type. Manage agents in your helpdesk and get an overview of the number of tickets they are handling per month divided by type. These metrics can be useful for performance reviews of agents, or simply to keep an eye how many tickets every agent is handling.
Count of Tickets per Agent, Month and Type Query
Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
htbltickettypes.typename Type,
htblusers.name As AssignedAgent,
Count(htblticket.ticketid) As TicketCount
From htblticket
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers On htblusers.userid = htblagents.userid
Inner Join htbltickettypes On htbltickettypes.tickettypeid =
htblticket.tickettypeid
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date),
htbltickettypes.typename,
htblusers.name
Order By Year Desc,
Month Desc,
Type,
AssignedAgent
