Can I report on tickets submitted via web vs tickets submitted via email?
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.
1 Comment
[ + ] Show comment
-
Was there an answer to this? I have the same question. - aoh 6 years ago
-
https://github.com/csteelatgburg/K1000-Database-Queries/blob/master/tickets%20-%20count%20of%20tickets%20opened%20by%20month%20via%20email%20or%20not.sql - chucksteel 6 years ago
Answers (1)
Answer Summary:
Please log in to answer
Posted by:
chucksteel
7 years ago
Top 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.
Comments:
-
Chuck, So I take it that this type of report cannot be created using the Report wizard? If true, would you have any links referencing sample sql queries on how to create a report on tickets created via_email? Thank you in advance for any assistance provided. - rmstech 6 years ago
-
I'm not at my office and can't provide more details for a while, but there is a query on my GitHub repo that can get you started. https://github.com/csteelatgburg/K1000-Database-Queries/blob/master/tickets%20-%20count%20of%20tickets%20opened%20by%20month%20via%20email%20or%20not.sql - chucksteel 6 years ago
-
Thank you... - rmstech 6 years ago
