Notification

Icon
Error

Cannot find right class

Posted: Monday, November 29, 2021 8:16:33 AM(UTC)
FabioB

FabioB

Member Original PosterPosts: 4
0
Like
Hi there,

I am currently in the process of creating an evaluation for our tickets. Unfortunately, I have a little problem with that. I can't find the right group for the type.

I can only find the ID and not the full name.

I mean this type here:

UserPostedImage

here my previous code:
Quote:
Select Top 1000000 htblticket.ticketid As [Ticket ID],
htblticket.subject As Betreff,
htblticket.date As Datum,
htblusers.name As [Erstellt von],
htblusers.company As Firma,
htblticketstates.statename As Status,
htblusers1.name As Agent,
htblpriorities.name As Priorität,
htblteams.teamname As Team
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
Inner Join lansweeperdb.dbo.htblpriorities On htblticket.priority =
htblpriorities.priority
Inner Join lansweeperdb.dbo.htblticketteam On htblticket.ticketid =
htblticketteam.ticketid
Inner Join lansweeperdb.dbo.htblteams On htblticketteam.teamid =
htblteams.teamid
Order By [Ticket ID]



Thank you in advance and have a nice time before Christmas!

Sincerely, Fabio

Active Discussions

Lansweeper Log4j report
by  LightUpDiFire  
Go to last post Go to first unread
Last post: Yesterday at 1:54:52 PM(UTC)
Lansweeper Linux Polkit Vulnerability
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 12:16:37 PM(UTC)
Lansweeper Combined Vulnerability Report Q1 2019
by  Hendrik.VE  
Go to last post Go to first unread
Last post: 1/24/2022 5:05:24 PM(UTC)
Lansweeper Microsoft Patch Tuesday – January 2022
by  Esben.D  
Go to last post Go to first unread
Last post: 1/18/2022 2:59:23 PM(UTC)
Lansweeper SCCM end of life
by  Esben.D   Go to last post Go to first unread
Last post: 1/18/2022 11:41:00 AM(UTC)