Good morning,

I'd like to make a report for the number of tickets created between a certain time (in this case when IT is off-hours - so between 4PM and 12AM daily). I haven't been able to figure out how to make such a report work properly. My preference would be for the report to output this by month and year but a total count would be fine. Thanks for any assistance you can provide.
Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answer Chosen by the Author

1
This should work:
SELECT YEAR(CREATED) AS TicketYears, MONTH(CREATED) AS TicketMonths, COUNT(ID) AS "Opened"
FROM ORG1.HD_TICKET 
WHERE TIME(CREATED) BETWEEN "16:00:00" and "23:59:59"
GROUP BY YEAR(CREATED), MONTH(CREATED)

Answered 04/29/2016 by: chucksteel
Red Belt

Please log in to comment

Answers

Answer this question or Comment on this question for clarity

Share