Notification

Icon
Error

Report to show all tickets that aren't assigned?

Posted: Friday, May 3, 2019 6:51:56 PM(UTC)
pryan67

pryan67

Member Original PosterPosts: 22
0
Like
I'm trying to find a report that will show me a list of all tickets that have been opened but not "picked up" yet.

Any suggestions? I've tried this with no luck:


Select Top 1000000 htblticket.ticketid As [Ticket Number],
htblticket.date As [Date Opened],
htblticket.updated As [Last Update],
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],
htblusers.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
Where htblticket.updated > DateAdd(day, DateDiff(day, 0, GetDate()), 0) And
htblusers.name Is Null
Order By [Last Update] Desc,
[Date Opened] Desc,
[Ticket State],
[Ticket Category]
pryan67
#1pryan67 Member Original PosterPosts: 22  
posted: 5/3/2019 8:55:09 PM(UTC)
So this is interesting. I modified it a little bit, but it's missing a significant number of tickets and I can't find any rhyme or reason to which are missing. It should be showing ALL tickets, from day one, yet I'm showing only 23 (there should be around 100...we just implemented it recently)


Select Top 1000000 htblticket.ticketid As [Ticket Number],
htblticket.date As [Date Opened],
htblticket.updated As [Last Update],
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 [Last Update] Desc,
[Date Opened] Desc,
[Ticket State],
[Ticket Category]

Active Discussions

Lansweeper Firefox 67.0.3 zero-day vulnerability
by  B Claeys   Go to last post Go to first unread
Last post: Today at 3:13:30 PM(UTC)
Lansweeper BlueKeep Vulnerability
by  heybobby1  
Go to last post Go to first unread
Last post: Today at 3:02:34 PM(UTC)
Lansweeper VLC Player CVE-2019-5439
by  Esben.D   Go to last post Go to first unread
Last post: Yesterday at 9:19:29 AM(UTC)
Lansweeper Enabled/Disabled Local/AD Admin accounts
by  vqT4cDoP9iXyMZwoDUWU  
Go to last post Go to first unread
Last post: 6/17/2019 9:12:30 PM(UTC)
Lansweeper code in posts
by  AZHockeyNut   Go to last post Go to first unread
Last post: 6/14/2019 4:39:46 PM(UTC)
Lansweeper Adding more info to asset report
by  RC62N   Go to last post Go to first unread
Last post: 6/13/2019 9:46:31 PM(UTC)
Report Center Top 5 Average RAM Usage
by  Esben.D  
Go to last post Go to first unread
Last post: 6/13/2019 1:15:31 PM(UTC)