Ticket creator report
Is it possible to report the userid that created each ticket? We change the submitter field to the name of the actual requester, so it doesn't reflect the help desk user that actually created the ticket.
0 Comments
[ + ] Show comments
Answers (4)
Please log in to answer
Posted by:
airwolf
14 years ago
You'd have to create a report that searched through comments for the "Ticket Created." comment. There is no field in the HD_TICKET table that tracks the creator - only submitter, approver, and owner; and it doesn't track the history anywhere but comments.
Try this:
Try this:
SELECT T.ID AS 'Ticket #', T.TITLE AS 'Issue',U.FULL_NAME AS 'Ticket Creator' FROM HD_TICKET_CHANGE TC
JOIN USER U ON (U.ID = TC.USER_ID)
JOIN HD_TICKET T ON (T.ID = TC.HD_TICKET_ID)
WHERE TC.DESCRIPTION like 'Ticket Created'
Posted by:
GillySpy
14 years ago
Minor correction since ticket created may not stand alone in all cases:
SELECT T.ID AS 'Ticket #', T.TITLE AS 'Issue',U.FULL_NAME AS 'Ticket Creator' FROM HD_TICKET_CHANGE TC
JOIN USER U ON (U.ID = TC.USER_ID)
JOIN HD_TICKET T ON (T.ID = TC.HD_TICKET_ID)
WHERE TC.DESCRIPTION like 'Ticket Created%'
Posted by:
MelaMaui
14 years ago
Hey Gerald,
That's exactly what I needed, Thanks. Can I sort that by ticket creator?
Carmela
That's exactly what I needed, Thanks. Can I sort that by ticket creator?
Carmela
Rating comments in this legacy AppDeploy message board thread won't reorder them,so that the conversation will remain readable.