Ticket Reports

Hey there!  I'm looking for a more detailed report on an archived ticket queue that I could run to show me the history of tickets.  I'm looking for items like:  created to opened, escalation points, times stalled, etc.  I know NOTHING about sql unfortunately, and have tested a few items that i've found online, but nothing compares to what i'm looking for.  Is this possible?  Thanks in advance!!  :)

3 Comments   [ + ] Show comments
  • We don't archive tickets (at this point), but the HD_TICKET* tables are replicated as HD_ARCHIVE_TICKET*. Have you tried taking a report for current tickets, performing a find replace HD_TICKET to HD_ARCHIVE_TICKET and running it? - chucksteel 1 year ago
  • Thanks for the reply! I can run reports on the archives and return data, however, there's nothing that shows me the history as far as how many owners touched it, the time difference between when the ticket was created to when it was actually opened (status update) or the history of the status changes. I was looking for some deeper metrics reporting than what i've found. - jfangman 1 year ago
    • Gotcha. I have one report that shows the time for owner changed and approval change in my repository:

      Most of the data you are looking to show is stored in HD_ARCHIVE_TICKET_CHANGE and HD_ARCHIVE_TICKET_CHANGE_FIELD, so you should be able to get to it.

      Are you interested in learning some SQL, or at least poking around in the tables to see what is there? If so, then I recommend setting up the external reporting and MySQL WorkBench.

      Otherwise, is there anyone on your team that could help with report writing? - chucksteel 1 year ago
  • Cool! Thanks for the info. And yes, one of my goals is to learn it. I've written HTML and my prev. college life included C++ but sql is a bit different. LOL! - jfangman 1 year ago

Answers (0)

Be the first to answer this question

Don't be a Stranger!

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

Sign up! or login


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