Crete a report that shows who created the ticket.

I don't see any canned reports that show me who "Created" a ticket. I can see when it was created, who it is assigned to, who is the submitter but that doesn't help me when I need to see how many tickets my help desk team has "Created". When they Create the ticket manually, they then assign it to someone and change the requester to who ever called it in. only way for me to truly see who or how it was created is to go into each one and check the history. 

0 Comments   [ + ] Show comments

Answers (1)

Posted by: Hobbsy 1 month ago
Red Belt

For this you will need to go to the HD_TICKET_CHANGE table rather than the HD_TICKET table.

You can then identify what comments are recorded when the ticket is logged and capture the date stamp for the report.

You will need to be connected to the database via ODBC to really get at this information 

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

View more:


This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ