TRY NOW

Helpdesk Agent Notes Sent in Last 7 Days

Helpdesk

Discover the Number of Replies of Helpdesk Agents in the Last Week

Get an overview of all your helpdesk agents and the number of replies they have sent in the last 7 Days. Keeping track of the performance of your agents is obviously important to keep service quality up to standard. The amount of replies or notes a helpdesk agent sends to end users also plays a part in servicing end users. This report shows agents and the number of notes they have sent the last week. Agent notes sent recently

Helpdesk Agent Notes Sent in Last 7 Days Query

Select Top 1000000 htblticket.ticketid,
  '#' + Cast(htblticket.ticketid As nvarchar) As Ticket,
  htblticket.date As CreationDate,
  htblticket.updated As LastUpdated,
  htbltickettypes.typename As Type,
  htblticketstates.statename As State,
  htblpriorities.name As Priority,
  htblsource.name As Source,
  htblusers.name As [User],
  htblusers1.name As AssignedAgent,
  '../helpdesk/icons/' + htbltickettypes.icon As icon,
  htblticket.subject As Subject,
  htblnotes.date As NoteSentDate,
  Case htblnotes.notetype
    When 1 Then 'Public Reply'
    When 2 Then 'Internal Note'
    Else 'Initial Ticket'
  End As NoteType,
  htblusers2.name As NoteSentBy
From htblticket
  Inner Join htblpriorities On htblpriorities.priority = htblticket.priority
  Inner Join htblticketstates On htblticketstates.ticketstateid =
    htblticket.ticketstateid
  Inner Join htblusers On htblusers.userid = htblticket.fromuserid
  Left Join htblagents On htblagents.agentid = htblticket.agentid
  Left Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
  Inner Join htbltickettypes On htblticket.tickettypeid =
    htbltickettypes.tickettypeid
  Inner Join htblsource On htblticket.sourceid = htblsource.sourceid
  Inner Join htblnotes On htblticket.ticketid = htblnotes.ticketid
  Inner Join htblagents htblagents1 On htblagents1.userid = htblnotes.userid
  Inner Join htblusers htblusers2 On htblusers2.userid = htblagents1.userid
Where htblnotes.date > GetDate() - 7 And htblticket.spam <> 'True'
Order By NoteSentDate Desc,
  htblticket.ticketid

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.