alerts query

[roopeshetty]

Hi Guys,

We have a alert setup for below query with condition when ever there is Number of Result greater than 0.

<query>| table ServerName UserName  SupportTeam

This query runs once in a day and triggers the alerts perfectly as expected. But now the management wants some modifications in alerting condition in such a way that trigger a alert if any ServerName is present continuously in 3 runs then only it should trigger the alert.

Example : If ServerName "APAC_Japan01” present in output of all 3 days query, then only it should alert for this ServerName, if it presents only on 1st and 2nd day output results then it should not trigger the alert. Can this be possible?

[ITWhisperer]

You can change your query so that it covers 3 days and buckets by day, and count the days which have greater than 0 results.