I need to create a report that will list ticket ID, Owner, and also ticket action for changed owner. Basically we want a report to show if a ticket changed owner once it was changed from the default. This is being used to track accuracy on assigning the ticket to the correct owner on the first go around. So i would want the report to show if the ticket changed owners more than once. Anyone know if that is possible.
1 Comment   [ + ] Show Comment

Comments

  • Yes, this is possible by pulling from the HD_TICKET_CHANGE table. The report would have to be built using MySQL, the wizard won't be able to create it. Do you have experience with MySQL?
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity