Helpdesk Ticket All history report
I cannot seem to find a way to get a report that shows all the ticket history for a queue.
I have gone through the reporting wizard but I don't see a field that marks ticket history. I want something that shows me everything i would see if I looked at the History tab of a given ticket.
I feel like I am missing something super obvious since the ticket itself shows the history.
Please log in to answer
Posted by: chucksteel 2 years ago
This is what I use:
SELECT T.ID, T.TITLE, USER.USER_NAME, C.ID, C.TIMESTAMP, C.COMMENT, C.DESCRIPTION, CF.FIELD_CHANGED, CF.AFTER_VALUE
FROM ORG1.HD_TICKET T
JOIN HD_TICKET_CHANGE C on C.HD_TICKET_ID = T.ID
JOIN HD_TICKET_CHANGE_FIELD CF on CF.HD_TICKET_CHANGE_ID = C.ID
JOIN USER on USER.ID = C.USER_ID
WHERE T.ID = "62577"
It isn't pretty, but it works.