/build/static/layout/Breadcrumb_cap_w.png

Systems Management Question


Is there any way to send to email addresses in multiple columns with a custom ticket rule?

12/04/2019 169 views

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

Comments


All 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!



Answered 12/05/2019 by: chrpetri
Blue Belt