Is there any way to send to email addresses in multiple columns with a custom ticket rule?
I am trying to use the custom ticket rule to run a daily query to list who needs to perform an OS upgrade and then email those people. That part is working perfectly fine. What I would like to figure out is if it is possible to also email a second list of email addresses? In this case it would be the persons manager via CC. There must be a way to do this..... Anyone?
Answers (1)
Hi,
I was able to do this by adding the additional recipients with CONCAT() and separate the E-Mail addresses with comma (did not try more than one).
Anyhow I see no chance to add them to CC. That means the recipients will not see each other in the "To:" header, everyone will get a separate E-Mail.
Tried something like this, using "MAILREC" for "Column containing email addresses":
Select
MACHINE.NAME AS COMPUTER,
MACHINE.OS_NAME,
MACHINE.USER_NAME,
MACHINE.USER_FULLNAME,
CONCAT(USER.EMAIL,',whatever@maildomain.com') AS MAILREC
From
MACHINE Inner Join
USER On USER.USER_NAME = MACHINE.USER_NAME
Cheers!
