KACE Product Support Question
KACE Reporting: count of tickets between certain hours
04/28/2016 901 views
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 Chosen by the Author
Please log in to answer
This should work:
SELECT YEAR(CREATED) AS TicketYears, MONTH(CREATED) AS TicketMonths, COUNT(ID) AS "Opened"
WHERE TIME(CREATED) BETWEEN "16:00:00" and "23:59:59"
GROUP BY YEAR(CREATED), MONTH(CREATED)
Answered 04/29/2016 by: chucksteel