/build/static/layout/Breadcrumb_cap_w.png

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!!  :)

Asked 5 years ago 355 views
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 5 years 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 5 years ago
    • Gotcha. I have one report that shows the time for owner changed and approval change in my repository:
      https://github.com/csteelatgburg/K1000-Database-Queries/blob/master/tickets%20showing%20owner%20and%20approval%20changes.sql

      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 5 years 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 5 years ago

Answers (0)

Be the first to answer this question

Posted by:

jfangman Senior White Belt
Ninja since: 10 years ago

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:

Miscellaneous Questions
question

Related Questions

Link

Related Links

Post

Related Posts

Share

 
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