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?
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