Sending scheduled report to groups "dynamically" based on report content?

[mechamberlain]

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!

[Mike Allen]

Yeah, just take what I have, query sys_user_grmember and grab all the member emails instead of the  group email.

[mechamberlain]

Yes...thanks.   I'll give it a shot.   Again, thanks for the responses!

[Mike Allen]

No worries.  It's what we're here for.

[jrobitzsch2016]

Thanks Mike - glad I can still rely on you for solutions even when our career paths fork - I hope you're doing well. We just raised this question today. We'll try to implement your solution as well.

[terrykim]

You are a very clever person, this worked really well and I would suggest this question is definitely answered.   I just had to make sure the script include used the same query filter as the report and the system returned the list of email addresses as required. This also taught me a bit about the way the business rule actually works. Thank you so much.