Count of Tickets per Agent, Month and Type

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, As Year,
  DatePart(mm, As Month,
  htbltickettypes.typename Type, 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 =
Group By DatePart(yyyy,,
Order By Year Desc,
  Month Desc,

Run This Report in 3 Easy Steps


1. Download & Install Lansweeper


3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting