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 How do you scan your assets on your network?
by  CyberCitizen   Go to last post Go to first unread
Last post: Today at 1:14:18 AM(UTC)
Lansweeper How EXACTLY Does LS Count Assets?
by  vqT4cDoP9iXyMZwoDUWU  
Go to last post Go to first unread
Last post: Yesterday at 10:14:48 PM(UTC)
Lansweeper URL for Custom Reports
by  Joe Conger   Go to last post Go to first unread
Last post: Yesterday at 6:52:06 PM(UTC)
Lansweeper Add Document as File Link
by  mowo  
Go to last post Go to first unread
Last post: Yesterday at 2:00:25 PM(UTC)
Lansweeper Table View Filter
by  tgt   Go to last post Go to first unread
Last post: Yesterday at 8:30:44 AM(UTC)
Lansweeper How to scan assets on a different network
by  twpseaton  
Go to last post Go to first unread
Last post: 6/25/2019 10:04:36 PM(UTC)
Lansweeper Lansweeper warnings sent to an email
by  MilicaM   Go to last post Go to first unread
Last post: 6/25/2019 2:23:29 PM(UTC)
Lansweeper ShellRunAs action in Lansweeper
by  DavidL  
Go to last post Go to first unread
Last post: 6/25/2019 11:58:07 AM(UTC)