Community FAQ
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Tholmes
Engaged Sweeper III
I have 6 types of tickets, Onboarding and offboarding, IT purchase, Infrastructure IT Support and project.
For all the other tickets I can easily tell why calls are slightly higher or lower, but the IT support one we have differences of 60-100 per month.
I want to be able to just break it down, we have 13 headings under IT support, how can I just run a report against those and just have the subheading from below come up?
I am a SQL dummy, I can bodge things together and sometimes make them work but I think this requires knowledge and finesse, SQL skills I am severely lacking.

I have this script that I thought I could modify to add the additional info from IT support, but I don't have the ability to amend to this code.
,
Select Top 1000000 DatePart(yyyy, htblticket.date) As Year,
DatePart(mm, htblticket.date) As Month,
htbltickettypes.typename Type,
htblusers.name As AssignedAgent,
Count(htblticket.ticketid) As TicketCount
From htblticket
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers On htblusers.userid = htblagents.userid
Inner Join htbltickettypes On htbltickettypes.tickettypeid =
htblticket.tickettypeid
Group By DatePart(yyyy, htblticket.date),
DatePart(mm, htblticket.date),
htbltickettypes.typename,
htblusers.name
Order By Year Desc,
Month Desc,
Type,
AssignedAgent

I tried modifying this script from here, but failed miserably.
Could anyone show me the light please?
As always, thanks in advance.
Tim
0 REPLIES 0

Reports & Analytics

Ask about reports you're interested in and share reports you've created. Subscribe to receive daily updates of reports shared in the Community.

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now