→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Fabio
Engaged Sweeper
Hello,
im made this report:

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,
htblusers.description As Beschreibung
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
Order By [Ticket ID]


is it possible to display the yellow text too?

1 REPLY 1
Fabio
Engaged Sweeper
Bumb

New to Lansweeper?

Try Lansweeper For Free

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

Try Now