KACE SQL Report
I am trying to run a report to show the total ticket count for a specific time frame. I just need a count for a psecific date range... no other data. What would the SQL for this look like?
0 Comments
[ + ] Show comments
Answers (1)
Please log in to answer
Posted by:
ondrar
5 years ago
This is for tickets created between October 1 and October 9, inclusive, and specific to one queue.
SELECT
COUNT(ID)
FROM HD_TICKET
WHERE
DATE(CREATED) BETWEEN '2018-10-01' AND '2018-10-09'
AND HD_QUEUE_ID = 5
