Notification

Icon
Error

Helpdesk report for tickets for all on one reason - But different sub reasons.

Posted: Monday, February 22, 2021 7:22:56 PM(UTC)
TimHolmes1973

TimHolmes1973

Member Original PosterPosts: 30
0
Like
I have set the HD up this way and need to run the report from this site.
https://www.lansweeper.c...bcategory.aspx#post55047
But I want to add each ticket reason beneath, not just one, so I thought this would work but it did not, how can I add the next category.
Reason for ticket>
Hardware Related
Software Related
ETC.
I can get it if just the hardware related is there, but when I try to add software related, it shows no results.
Any advice please.

Select Distinct Top 1000000 htblticket.ticketid,
'#' + Cast(htblticket.ticketid As nvarchar) As Ticket,
htblticket.date,
htbltickettypes.typename,
htblticketstates.statename,
htblticket.subject,
htblusers1.name As [User Name],
htblusers.name As [Help Desk Agent Name],
Reasonforticket.data As [Reason for ticket],
HardwareRelated.data As [Hardware Related],
SoftwareRelated.data As [Software Related]
From htblticket
Left Join htblagents On htblagents.agentid = htblticket.agentid
Left Join htblusers On htblusers.userid = htblagents.userid
Inner Join htblusers htblusers1 On htblusers1.userid = htblticket.fromuserid
Left Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htbltickettypes On htbltickettypes.tickettypeid =
htblticket.tickettypeid
Inner Join (Select Top 1000000 htblticketcustomfield.ticketid,
htblticketcustomfield.data
From htblticketcustomfield
Inner Join htblcustomfields On htblcustomfields.fieldid =
htblticketcustomfield.fieldid
Where htblcustomfields.name Like 'Reason For Ticket') As Reasonforticket
On htblticket.ticketid = Reasonforticket.ticketid
Inner Join (Select Top 1000000 htblticketcustomfield.ticketid,
htblticketcustomfield.data
From htblticketcustomfield
Inner Join htblcustomfields On htblcustomfields.fieldid =
htblticketcustomfield.fieldid
Where htblcustomfields.name Like 'Hardware Related') As HardwareRelated On
htblticket.ticketid = HardwareRelated.ticketid
Inner Join (Select Top 1000000 htblticketcustomfield.ticketid,
htblticketcustomfield.data
From htblticketcustomfield
Inner Join htblcustomfields On htblcustomfields.fieldid =
htblticketcustomfield.fieldid
Where htblcustomfields.name Like 'Software Related') As SoftwareRelated On
htblticket.ticketid = SoftwareRelated.ticketid

Active Discussions

Lansweeper Creating a schduled task on remote computer
by  Amos   Go to last post Go to first unread
Last post: 2/21/2021 10:57:02 AM(UTC)
Lansweeper Uninstall Software action not working?
by  Brandon  
Go to last post Go to first unread
Last post: 2/15/2021 10:03:22 PM(UTC)
Action Connect to computer using Spashtop Business
by  TapeDeck   Go to last post Go to first unread
Last post: 1/29/2021 5:00:29 PM(UTC)
Action Check Asset Window Update Status Via Powershell
by  Andy.S  
Go to last post Go to first unread
Last post: 1/19/2021 3:30:09 PM(UTC)
Lansweeper Updating Active Directory User fields
by  Nuno   Go to last post Go to first unread
Last post: 1/7/2021 5:49:03 PM(UTC)
Action Ping Sweep a Subnet
by  Computer Doctor  
Go to last post Go to first unread
Last post: 12/23/2020 7:16:01 PM(UTC)
Lansweeper User actions
by  makitaEU   Go to last post Go to first unread
Last post: 12/9/2020 1:57:07 PM(UTC)
Action Remote Uninstaller
by  miek_g  
Go to last post Go to first unread
Last post: 10/28/2020 3:52:20 PM(UTC)