I have an alert that is running on 5 minute cron schedule looking for a number of results. I am looking to set up the action or the search itself to only fire when that condition has been met over multiple 5 minute intervals. The number of results is less important then the sustained occurrence, so just raising the number of results in the trigger condition wouldn’t help.
Example today, If xx is greater then 10 in 5 minutes, trigger an alert.
Ideally, If xx is greater then 10 in 5 minutes for 4 intervals in a row, trigger an alert.
Try this. Run this every 25mins (not 5 mins) and alert only if value of alert = 5
index=_internal earliest=-25m@m | timechart partial=f span=5m count | eval alert=0 | foreach count [eval alert=if(count<500, 0, 1)] | addcoltotals | where isnull(_time)