SQL Help - Send Email to Different Distribution Lists Based on Custom_1 Input (K1200)
I have setup a custom ticket rule as per http://www.kace.com/support/resources/kb/article/How-To-Notify-Any-User-or-Group-by-Email-When-a-New-Help-Desk, which works wonderfully for sending email to just the one distribution list on ticket creation. I would like help modifying the query to send to different distribution lists based on values stored in the Custom_1 field. We use Custom_1 for site lists, and each site has a specific distribution list associated with it.
So, for example, if a new ticket is created and the Custom_1 option "Central Office" is selected, an email is generated and sent to the "firstname.lastname@example.org". If the Custom_1 option "Annex" is selected instead, an email is generated and sent to "email@example.com".
I've tried for several days now to get it to work, but I'm at a loss. I'm no SQL expert, but if someone could point me in the right direction it would be greatly appreciated.