/build/static/layout/Breadcrumb_cap_w.png

KACE Product Support Question


KACE Reporting: count of tickets between certain hours

04/28/2016 901 views
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:
0 Comments   [ + ] Show comments

Comments


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

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ