/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 314 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

 
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