Miscellaneous : Ticket Rule - Can I send to an email address not returned by the query

Ticket Rule - Can I send to an email address not returned by the query

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

0 Comments [ + ] Show comments

Answers (1)

Answer Summary:

Posted by: chucksteel 11 years ago

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.

Comments:

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 - jmarotto 11 years ago

Answer this question

Posted by:

View more:

Miscellaneous Questions

question