Custom Report in Kace
I am looking for some help on a report. I am trying to create a report of tickets by team that are not closed, which will show the ticket number, ticket owner and the date and time they were put in a status of “Assigned” then the date and time they were placed in a status of “Active”. Any help would be appreciated.
Community Chosen Answer
SELECT T.ID, O.FULL_NAME, ASSIGNED.TIMESTAMP as "Assigned", ACTIVE.TIMESTAMP as "Active"
FROM HD_TICKET T
JOIN USER O on O.ID = T.OWNER_ID
JOIN HD_TICKET_CHANGE ASSIGNED on ASSIGNED.HD_TICKET_ID = T.ID and ASSIGNED.DESCRIPTION like "%Status%to%Assigned%"
JOIN HD_TICKET_CHANGE ACTIVE on ACTIVE.HD_TICKET_ID = T.ID and ACTIVE.DESCRIPTION like "%Status%to%Active%"
JOIN HD_STATUS on HD_STATUS.ID = T.HD_STATUS_ID
WHERE T.HD_QUEUE_ID = 2
and HD_STATUS.STATE != 'closed'