/build/static/layout/Breadcrumb_cap_w.png

Was ticket Emailed or Portal?

Is there a way to tell if the ticket was started by and Email or through the portal?  There is a warning I need to put in my new ticket reply based on how the ticket was created.  Is there a field that indicates this?


2 Comments   [ + ] Show comments
  • You could probably derive that information based on if a required field is set or not via a
    Custom service desk rule. - Jbr32 10 years ago
  • Do you have the table names and what to look for. I have the dbForge Query Builder to take a look - JordanNolan 10 years ago

Answers (1)

Posted by: chucksteel 10 years ago
Red Belt
0

The HD_TICKET_CHANGE table includes a column named VIA_EMAIL which indicates the email address that the change came from. You could check the initial comment on a ticket to see if that column is empty or not.


Comments:
  • Thanks Chuck,

    Do you know if it is possible to see if there is a CC on the ticket as well. I am also currently trying to see why an email comes in with a CC, they are not on the ticket. If the Dell KACE team cannot resolve this I may have to sharpen my SQL skills and find a way to parse it out myself. - JordanNolan 10 years ago
    • I don't believe KACE tracks whether someone is copied on the email to the service desk that creates the ticket. - chucksteel 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

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