‎07-09-2018 10:36 PM
Select Top 1000000 Count_Big(htblticket.ticketid) As Tickets,
tblADusers.Department
From htblticket,
tblADusers
Group By tblADusers.Department
‎07-11-2018 05:04 PM
The report looks at the department of the agent of a ticket (so the agent must be an AD user with that department).
‎07-10-2018 11:31 AM
Select Top 1000000 Count(htblticket.ticketid) As NumberOfTickets,
tblADusers.Department,
htblteams.teamname
From htblticket
Inner Join htblticketteam On htblticket.ticketid = htblticketteam.ticketid
Inner Join htblteams On htblteams.teamid = htblticketteam.teamid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers On htblusers.userid = htblagents.userid
Inner Join tblADusers On tblADusers.Username = htblusers.username And
tblADusers.Userdomain = htblusers.userdomain
Where tblADusers.Department = 'IT Department '
Group By tblADusers.Department,
htblteams.teamname
‎07-17-2018 07:51 PM
Charles.X wrote:
You can try this report. It should show a count of ticket per team for a specified department. The report looks at the department of the agent of a ticket (so the agent must be an AD user with that department).
You can change the department I highlighted below to your own department names.Select Top 1000000 Count(htblticket.ticketid) As NumberOfTickets,
tblADusers.Department,
htblteams.teamname
From htblticket
Inner Join htblticketteam On htblticket.ticketid = htblticketteam.ticketid
Inner Join htblteams On htblteams.teamid = htblticketteam.teamid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers On htblusers.userid = htblagents.userid
Inner Join tblADusers On tblADusers.Username = htblusers.username And
tblADusers.Userdomain = htblusers.userdomain
Where tblADusers.Department = 'IT Department '
Group By tblADusers.Department,
htblteams.teamname
It is possible to have different departments in different columns, but this would require subqueries which is more work.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now