→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JasonGood
Engaged Sweeper
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
1 REPLY 1
Dan_Ratje
Engaged Sweeper
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