
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-11-2017 10:59 PM
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
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
Labels:
- Labels:
-
Report Center
1 REPLY 1

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-24-2017 11:34 PM
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
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
