‎01-08-2016 04:47 PM
Select Top 1000000 htblticket.date As [Date Opened],
htblticket.slaresolved As [Date Closed / Resolved],
htbltickettypes.typename As [Ticket Category],
htblticketstates.statename As [Ticket State],
tblAssets.AssetName As Asset,
htblticket.subject As Subject,
htblusers.name As [User],
htblusers1.name As Agent
From htblticket
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htbltickettypes On htblticket.tickettypeid =
htbltickettypes.tickettypeid
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Inner Join htblagents On htblagents.agentid = htblticket.agentid
Inner Join htblusers htblusers1 On htblagents.userid = htblusers1.userid
Inner Join tblAssets On htblticket.assetid = tblAssets.AssetID
Order By [Ticket State],
[Ticket Category],
[Date Opened]
‎05-25-2017 03:20 PM
‎03-08-2017 11:01 PM
‎01-20-2016 12:08 PM
‎01-15-2016 10:42 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now