Alerting
Highlighted

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

Explorer

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:

alt text

For the above result I would need two email alerts, one for the filename asd123 and another for qwe789 like below:

alt text

Please let me know if this thing is possible or not and if possible please let me know the solution.

Thanks.

0 Karma
Highlighted

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

SplunkTrust
SplunkTrust

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

0 Karma