Notification

Icon
Error

Opened Help Desk tickets report during a specific time of the day

Posted: Friday, June 28, 2019 5:11:50 PM(UTC)
gw2dave

gw2dave

Member Original PosterPosts: 1
0
Like
Is it possible to create a report that shows all the helpdesk tickets opened between 4:30pm -6:30pm Monday – Friday? There is a HD report that shows all tickets opened in a month and I'm just wondering if I can get more specific in terms of time and day.
Adam P.
#1Adam P. Member Posts: 3  
posted: 12/21/2020 3:07:34 PM(UTC)
Originally Posted by: gw2dave Go to Quoted Post
Is it possible to create a report that shows all the helpdesk tickets opened between 4:30pm -6:30pm Monday – Friday? There is a HD report that shows all tickets opened in a month and I'm just wondering if I can get more specific in terms of time and day.


Did you ever figure this out? I'm looking to do the same thing.
Brandon
#2Brandon Member Posts: 175  
posted: 1/4/2021 6:57:22 PM(UTC)
Originally Posted by: gw2dave Go to Quoted Post
Is it possible to create a report that shows all the helpdesk tickets opened between 4:30pm -6:30pm Monday – Friday? There is a HD report that shows all tickets opened in a month and I'm just wondering if I can get more specific in terms of time and day.


I was able to narrow it down between Monday and Friday, but not the times. Here is the code. I used the Tickets created in the last 7 days canned report and edited it:

Quote:
Select Top 1000000 htblticket.ticketid,
'#' + Cast(htblticket.ticketid As nvarchar) As Ticket,
htblticket.date As CreationDate,
htblticket.updated As LastUpdated,
htbltickettypes.typename As Type,
htblticketstates.statename As State,
htblpriorities.name As Priority,
htblsource.name As Source,
htblusers.name As [User],
htblusers1.name As AssignedAgent,
htblusers2.name As UserLastNote,
'../helpdesk/icons/' + htbltickettypes.icon As icon,
htblticket.subject As Subject
From htblticket
Inner Join htblpriorities On htblpriorities.priority = htblticket.priority
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Left Join htblagents On htblagents.agentid = htblticket.agentid
Left Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
Inner Join htbltickettypes On htblticket.tickettypeid =
htbltickettypes.tickettypeid
Inner Join htblsource On htblticket.sourceid = htblsource.sourceid
Inner Join htblusers htblusers2 On htblticket.userid_lastnote =
htblusers2.userid
Where DatePart(WEEKDAY, htblticket.date) In (2, 3, 4, 5, 6) And
htblticket.spam <> 'True'
Order By htblticket.ticketid
aamato
#3aamato Member Posts: 4  
posted: 10/15/2021 3:34:10 PM(UTC)
I can get you the hour side of it:

Where DatePart(WEEKDAY, htblticket.date) In (2, 3, 4, 5, 6) And
DatePart(HOUR, htblticket.date) Between 16 And 19 AND
htblticket.spam <> 'True'


The minute side still gives me issues.


Originally Posted by: Brandon Go to Quoted Post
Originally Posted by: gw2dave Go to Quoted Post
Is it possible to create a report that shows all the helpdesk tickets opened between 4:30pm -6:30pm Monday – Friday? There is a HD report that shows all tickets opened in a month and I'm just wondering if I can get more specific in terms of time and day.


I was able to narrow it down between Monday and Friday, but not the times. Here is the code. I used the Tickets created in the last 7 days canned report and edited it:

Quote:
Select Top 1000000 htblticket.ticketid,
'#' + Cast(htblticket.ticketid As nvarchar) As Ticket,
htblticket.date As CreationDate,
htblticket.updated As LastUpdated,
htbltickettypes.typename As Type,
htblticketstates.statename As State,
htblpriorities.name As Priority,
htblsource.name As Source,
htblusers.name As [User],
htblusers1.name As AssignedAgent,
htblusers2.name As UserLastNote,
'../helpdesk/icons/' + htbltickettypes.icon As icon,
htblticket.subject As Subject
From htblticket
Inner Join htblpriorities On htblpriorities.priority = htblticket.priority
Inner Join htblticketstates On htblticketstates.ticketstateid =
htblticket.ticketstateid
Inner Join htblusers On htblusers.userid = htblticket.fromuserid
Left Join htblagents On htblagents.agentid = htblticket.agentid
Left Join htblusers htblusers1 On htblusers1.userid = htblagents.userid
Inner Join htbltickettypes On htblticket.tickettypeid =
htbltickettypes.tickettypeid
Inner Join htblsource On htblticket.sourceid = htblsource.sourceid
Inner Join htblusers htblusers2 On htblticket.userid_lastnote =
htblusers2.userid
Where DatePart(WEEKDAY, htblticket.date) In (2, 3, 4, 5, 6) And
htblticket.spam <> 'True'
Order By htblticket.ticketid


Active Discussions

Lansweeper Marking/Flagging VIP Customers
by  C Johnson   Go to last post Go to first unread
Last post: Yesterday at 11:43:22 PM(UTC)
Lansweeper Office 2016 key scanning
by  WaldoIT  
Go to last post Go to first unread
Last post: Yesterday at 3:40:41 PM(UTC)
Lansweeper Configuring SSL in IIS Express issue
by  saffo   Go to last post Go to first unread
Last post: Yesterday at 9:57:31 AM(UTC)
Lansweeper MDM Jamf School
by  Eugene  
Go to last post Go to first unread
Last post: 12/3/2021 6:21:44 PM(UTC)
Lansweeper HTTPS not secure
by  Luke Maslany   Go to last post Go to first unread
Last post: 12/3/2021 2:23:28 PM(UTC)
Lansweeper Problem with deploy software
by  Max90  
Go to last post Go to first unread
Last post: 12/3/2021 2:04:12 PM(UTC)
Lansweeper scanning target by range
by  Colombini   Go to last post Go to first unread
Last post: 12/3/2021 12:06:19 PM(UTC)
Lansweeper Log WIFI networks
by  BastiOn  
Go to last post Go to first unread
Last post: 12/3/2021 10:29:38 AM(UTC)