Helpdesk Report

[JasonGood]

Hello,

I am just beginning to deploy the helpdesk feature of Lansweeper, but cannot find a report that we use for reporting. I am looking for a report that will return the Agent's name, and number of tickets closed/resolved over the past year. I have looked at editing one of the built-in reports, agents per month, but have not been successful at creating a working report. Would someone help with this?

Thanks in advance,
Jason

[Dan_Ratje]

I used the following report for gathering the agents and the closed tickets in the last year.

Select Top 1000000 htblusers1.name As Agent,
Count(htblticket.ticketid) As Count
From htblticket
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
Where htblticket.updated > GetDate() - 365 And htblticketstates.statename =
'Closed'
Group By htblusers1.name