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 SSL with IIS Express Not working
by  fjca   Go to last post Go to first unread
Last post: Yesterday at 8:16:46 PM(UTC)
Lansweeper LsAgent Reliability Problems
by  marck1024  
Go to last post Go to first unread
Last post: Yesterday at 2:09:29 PM(UTC)
Lansweeper 32-BIT Linux LsAgent-linux
by  Anup Chhetri   Go to last post Go to first unread
Last post: Yesterday at 1:30:15 PM(UTC)
Lansweeper Default Scanned item intervals
by  SteelOG  
Go to last post Go to first unread
Last post: 1/25/2022 8:22:45 PM(UTC)
Lansweeper How to delete an asset
by  tgas   Go to last post Go to first unread
Last post: 1/25/2022 4:00:10 PM(UTC)
Lansweeper Can you track local printers attached to Desktops?
by  hirogen  
Go to last post Go to first unread
Last post: 1/25/2022 2:48:22 PM(UTC)
Lansweeper Duplicates - different IP address
by  Lenven   Go to last post Go to first unread
Last post: 1/25/2022 2:12:40 PM(UTC)
Lansweeper Antivirus Up to Date or Not?
by  Lindner  
Go to last post Go to first unread
Last post: 1/25/2022 12:46:21 PM(UTC)