KACE Product Support Question
Hardware category report for the past 30 days
We are trying to create a report for all tickets opened under the Hardware category over the past 30 days in a specific queue.
We have run the following SQL query, but this is generating all tickets from all categories in the specific queue:
SELECT T.ID AS 'Ticket #', T.TITLE AS 'Issue', S.NAME AS 'Status' FROM HD_TICKET T
JOIN HD_STATUS S ON (T.HD_STATUS_ID = S.ID)
WHERE DATEDIFF(NOW(), CREATED) < 30 AND T.HD_QUEUE_ID = 1
If anyone could provide any additional info on getting the Hardware category isolated in the report that would be great.
Thanks in advance!