How to trigger alert emails for each of the unique ids that will have more than one rows?

[isamrat]

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.

Thanks.

[somesoni2]

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".