Helpdesk: Count of tickets per agent, last 7 days (Built-in)

[Nick_VDB]

Added in v.6.0.100

The report below lists the count of tickets that the agent created in the last 7 days.

The report will only count tickets that meet all of the following criteria:

• The user must be an agent.
  
• The ticket were made in the last 7 days.
  

Select Top 1000000 htblusers.name As AssignedAgent,
  htblusers.username,
  htblusers.userdomain,
  Case htblagents.active When 1 Then 'Yes' Else 'No' End As IsLicensed,
  Count(htblticket.ticketid) As TicketCount
From htblticket
  Inner Join htblagents On htblagents.agentid = htblticket.agentid
  Inner Join htblusers On htblusers.userid = htblagents.userid
Where htblticket.date > GetDate() - 7 And htblticket.spam <> 'True'
Group By htblusers.name,
  htblusers.username,
  htblusers.userdomain,
  htblagents.active
Order By AssignedAgent