I want to get alert emails for each of the unique ids that the query will return, and the unique Ids may have more than one row. For example:
Suppose my system will process the incoming files and the file name will get logged. The report for 15 mins may look like below:
For the above result I would need two email alerts, one for the filename asd123 and another for qwe789 like below:
Please let me know if this thing is possible or not and if possible please let me know the solution.
Try something like this
Update your alert search like this
your current search giving fields FileName ServiceName Status "Unique Id"
| stats list(*) as * by "Unique Id" | table FileName ServiceName Status "Unique Id"
On alert Action page, set the Alert options to be "For each result".