• 0 Vote(s) - 0 Average
  • 5
  • 4
  • 3
  • 2
  • 1
Thread Modes

Report question: Ticket opened after certain time
#1
Our Support group is asking if we can pull a report that shows what tickets were opened after a specific time of day for multiple days. They are trying to determine the number of tickets opened during their new extended hours versus their regular hours.
drobert5, proud to be a member of EV CONNECT FORUM since Jan 2017.

#2
(05-09-2018, 02:15 PM)drobert5 Wrote: Our Support group is asking if we can pull a report that shows what tickets were opened after a specific time of day for multiple days. They are trying to determine the number of tickets opened during their new extended hours versus their regular hours.

Hello,
You should use SQL query like :

Code:
SELECT     REQUEST_ID, SUBMIT_DATE_UT, DATEPART(hh, SUBMIT_DATE_UT) AS Expr1
FROM         [40000].SD_REQUEST
WHERE     (SUBMIT_DATE_UT > '01/01/2018') AND (DATEPART(hh, SUBMIT_DATE_UT) BETWEEN '10' AND '11')

P.ABBE
ABBE Philippe, proud to be a member of EV CONNECT FORUM since Nov 2015.






Users browsing this thread: 1 Guest(s)