Working on a ticket rule that sends an email to a specific person. When selecting 'Send an email for each result row' can I just put the email address in the 'Email Column:' field?

If not, how do I incorporate the email address I wish to send to into the query when it doesn't belong to one of the usual participants (owner, submitter, approver, updater so on)?

 

Thanks

Answer Summary:
Cancel
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Answers

1

You need to modify the SQL select statement to have it return the email address. This KB article outlines the procedures:

http://www.kace.com/support/resources/kb/article/How-To-Notify-Any-User-or-Group-by-Email-When-a-New-Help-Desk 

Basically you need to add a line like this to the select statement:

'helpdesk@mycompany.com' AS NEWTICKETEMAIL -- $newticketemail

You then use NEWTICKETEMAIL as the email column.

Answered 06/20/2013 by: chucksteel
Red Belt

  • Thank you Sir. I knew I had come across that line before but couldn't remember it for the life of me.

    Thanks again
    John
  • This content is currently hidden from public view.
    Reason: Member has been banned from the site
    For more information, visit our FAQ's.
Please log in to comment
Answer this question or Comment on this question for clarity

Share