Jetzt Ausprobieren

Count of Tickets per Agent, Month and Type

Helpdesk

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

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

Show

Hide