/build/static/layout/Breadcrumb_cap_w.png

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?



evfvXB9B7SiU6orMIECBAgAABAgQIECBAgAABAgQIECBAYG8EBJXolK+DysPDw7J+jsr6enp6ul0sokSHcxYBAgQIECBAgAABAgQIECBAgAABAgQI7KWAoBKddRdUnp+fl8fHx+0JlTWonJycRC92FgECBAgQIECAAAECBAgQIECAAAECBAgQ2F8BQSW67X8Fld0TKtGznUWAAAECBAgQIECAAAECBAgQIECAAAECBPZSQFCJziqoRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEgBQSU6u6ASHcZZBAgQIECAAAECBAgQIECAAAECBAgQIDBSQFCJzi6oRIdxFgECBAgQIECAAAECBAgQIECAAAECBAiMFBBUorMLKtFhnEWAAAECBAgQIECAAAECBAgQIECAAAECIwUElejsgkp0GGcRIECAAAECBAgQIECAAAECBAgQIECAwEiBfwBWZlub8cbbkgAAAABJRU5ErkJggg==


0 Comments   [ + ] Show comments

Answers (1)

Posted by: chrpetri 1 year ago
Blue Belt
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!



 
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