I have one alert stanza in my savedsearches.conf. Now, I want to dynamically send email notifications to the consumers based on the output of the result query. Suppose the alert query will give me the below output table after one run:
Now, based on the consumer names, I should be getting email alerts to different **email Ids** with different email subjects dynamically. So that I don't need to set up multiple alert stanzas in savedsearches.conf for different email recipients.
Please let me know how I can implement this.
have you seen this answer?
I think this might be an approach that will work for your ask.
This documentation might also help. If there is a way you can join email addresses to the consumer, you could use $result.email$ in the To field of the alert.
Thanks for your insights. But I would rather prefer to have some solution based on scripting. Let me know if you have any solution based on scripting.