/build/static/layout/Breadcrumb_cap_w.png

Reporting the "Action" field for ticket comments (i.e. Ticket title Changed from...)

I can't seem to find the field that the Action column in ticket comments are stored in - separate from the Action Taken field.

I'm looking for a way to report who has the most number of ticket assignments (i.e. User1 Changed ticket owner from "Unassigned" to "User2").

Any advice? Doesn't seem to be accessible with the report wizard.

3 Comments   [ + ] Show comments
  • How about some custom SQL with a count function, group by user? - Jbr32 9 years ago
  • Going along with Jbr32 here, I think it would be better to look at the OWNER_ID column and group by that rather than trying to count from the change descriptions. If you want to include past ticket owners and not just the current then you would need to use the change tables but you would probably have better success using the HD_TICKET_CHANGE_FIELD table. - chucksteel 9 years ago
  • Thanks for the input, gentlemen!

    I specifically don't want to query by ticket owner. A lot of work done is assigning tickets to other technicians (site techs resolve hardware issues) and we need a way to measure that metric. Since they assign it to someone else, they are not the owners, and tickets are often assigned by one technician without them ever owning it directly.

    I'll try the HD_TICKET_CHANGE_FIELD, thanks for the tip. Can you suggest how I'd see what fields are in that table? I'm not quite sure how to track that info down. I could probably write the query myself, but without some sort of root access I'm not sure how to query the tables for their fields. - colbya 9 years ago
    • There is a reporting user that has read access to the database. Check in Settings, Security Settings to make sure that it is enabled. Once that is enabled you can use a tool like MySQL Workbench to browse the tables and build reports. - chucksteel 9 years ago
      • Chuck, that was EXACTLY what I needed. I really appreciate your help! I wasn't even aware that there was a MySQL Reporting user. I was able to track that info down in the documentation and log in with the Workbench just like you said. Lifesaver! - colbya 9 years 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

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