I have a requirement where I have to send alerts to multiple email IDs stored in a sql server table. I have tested Watcher to send out alerts via email but not able to configure it for email IDs stored in table.
I have explored we can use script for dynamic values and we can store the values in elasticsearch as well but struggling to implement it for my requirement.
If anybody has implemented a similar requirement or can suggest any solution that would be a great help!!
One more point to add, if there are multiple alerts for a single contact in last 15 mins I want to send him alert once rather than multiple times.
Thanks in advance!