Can I report on tickets submitted via web vs tickets submitted via email?
08/23/2016 1085 views
Hi! I know this seems silly but I have to be able to report on our users who submit a ticket via email and users who submit a ticket in the kace web interface. Is there an easy way to do this? When I look at a ticket that was submitted via email it is labeled in the ticket next to the user's name so I know that kace can tell the difference. I just can't figure out how kace stores this information. I have access to KACE through mysqlworkbench but am relatively new to sql. If there is an easy way to pull this report that would be great otherwise if someone knows how kace stores this information that would be helpful as well.
Answer Chosen by the Author
Please log in to answer
This data is stored in the HD_TICKET_CHANGE table. If the change is triggered via an email (a new ticket is considered a change) then the VIA_EMAIL column will contain the email address that triggered it. To determine if a ticket was generated via email you can get the initial change per ticket and then check if there is a value in the VIA_EMAIL column.
Answered 08/24/2016 by: chucksteel