Hello!
I need help created a custom triggered alert condition where when I run the search below it will send me an alert when there is a new version created compared to the versions that were listed yesterday. So the trigger alert would run once each day and if I had 1.1.1 and 1.1.2 the day before but yesterday I had it give me results with 1.1.1, 1.1.2, 1.1.3 then to send me an alert when that new version is detected. How would I go about setting up that custom alert?
| inputlookup program_version.csv
| where date>=relative_time(now(), "-30d@d")
| eval _time=date
| timechart max(count) by version
If we're only interested in yesterday and today then there's no need to look back 30 days. We'll look at two days, find the difference between them, and trigger an alert if there is one.
| inputlookup program_version.csv
| where date>=relative_time(now(), "-1d@d")
| eval _time=date
| timechart max(count) as count by version
| eventstats range(count) as diff
| where diff!=0