I have two lookup tables that get updated 1/day from time/CPU intensive searches. I want to create an alert to let me know when there are deltas between these two lookup tables. I can schedule as a report, and this works, but then I get empty reports if not deltas are found. I think the reason my alert is not triggering is because the results from my search are not showing as events, but as statistics. |inputlookup main.csv |lookup secondary.csv eventSource as eventSource output Name|where isNull(Name) "Trigger Number of Results" = greater than 0 the search returns results, but no alert is triggered.
... View more