Hello. I'm wondering if anyone has tackled this previously. Here's the scenario...
I have the need to send a scheduled report to one or more Groups depending on the results in the report. For example:
This report creates a list of Application CI's that have no Description on them. I would like this to run as a "Scheduled Report" and have the results sent automatically to all of the Assignment Groups on the CI's listed in the report. So the example report would be sent to everyone in the Amsterdam, Boston, and Austin groups. I know how to schedule reports, it's the sending to the target groups I struggle with.
Not sure if this can be done, but wondering if anyone's tackled this. Thanks for your time and attention!
I have not tried it with this, but I bet you can create a script include that gathered the required email addresses, then called it in the scheduling of it, like this:
OK, I did it, but it isn't elegant. I put a business rule on the email table that looked for a specific subject from the Scheduled Report (you can trigger it off anything, really):
Then had a script include:
And it did what I wanted.
My queries are simplistic, but it worked. Just change the queries up to what you want to get the email addresses.
