Helpdesk Agent Notes Sent in Last 24 Hours

Find The Replies Sent by a Helpdesk Agent

Get an overview of all your helpdesk agents and the replies they have sent in the last 24 hours. 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 notes they have sent the last day for a more in-depth look.

Helpdesk Agent Notes Sent in Last 24 Hours Query

Select Top 1000000 htblticket.ticketid,
  '#' + Cast(htblticket.ticketid As nvarchar) As Ticket, As CreationDate,
  htblticket.updated As LastUpdated,
  htbltickettypes.typename As Type,
  htblticketstates.statename As State, As Priority, As Source, As [User], As AssignedAgent,
  '../helpdesk/icons/' + htbltickettypes.icon As icon,
  htblticket.subject As Subject, As NoteSentDate,
  Case htblnotes.notetype
    When 1 Then 'Public Reply'
    When 2 Then 'Internal Note'
    Else 'Initial Ticket'
  End As NoteType, As NoteSentBy
From htblticket
  Inner Join htblpriorities On htblpriorities.priority = htblticket.priority
  Inner Join htblticketstates On htblticketstates.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 =
  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 > GetDate() - 1 And htblticket.spam <> 'True'
Order By NoteSentDate 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