Community FAQ
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

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