About
Careers
Support
Partners
Community
Contact
Product
Overview
IT Discovery
IT Inventory
IT Analytics
Features
Integrations
Use Cases
IT Asset Management
Cybersecurity
Active Directory Audit
Installing Software & Patches
Automated IT Inventory
Pricing
Resources
Support Knowledge Base
Videos
Testimonials
Vulnerability Updates
Patch Tuesday
Blog
Free Download
Lansweeper
»
Report Questions
»
Opened Help Desk tickets report during a specific time of the day
Active Topics
Search
Join Now
Login
Notification
Error
OK
Opened Help Desk tickets report during a specific time of the day
Posted:
Friday, June 28, 2019 5:11:50 PM(UTC)
gw2dave
Member
Original Poster
Posts: 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.
#1
Adam P.
Member
Posts: 3
posted:
12/21/2020 3:07:34 PM(UTC)
Originally Posted by: gw2dave
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.
User Profile
View All Posts by User
View helpful posts
#2
Brandon
Member
Posts: 77
posted:
1/4/2021 6:57:22 PM(UTC)
Originally Posted by: gw2dave
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
User Profile
View All Posts by User
View helpful posts
Active Discussions
Rest API for Scanning
by
Brian Smith
Last post:
Today
at 7:35:27 PM(UTC)
Language translation not working anymore
by
Florian
Last post:
Today
at 6:03:19 PM(UTC)
Use current user for scanning credentials?
by
pryan67
Last post:
Today
at 6:01:33 PM(UTC)
Bluetooth Info
by
FrankSc
Last post:
Today
at 5:42:59 PM(UTC)
Question about Scanning Assets and Password Encryption
by
FrankSc
Last post:
Today
at 5:23:05 PM(UTC)
How to enable HTTPS in ver 6.0.150.60
by
Duncan.Miles
Last post:
Today
at 1:11:19 PM(UTC)
INFO DateTimeService time refresh
by
miharix
Last post:
Yesterday
at 3:22:29 PM(UTC)
MS Edge Chromium LanSweeper Extension development
by
Slim D
Last post:
1/15/2021 11:39:29 AM(UTC)