Hello,
I'm trying to set up an alert for when some event type stops happening.
Given multiple event types, each of which should happen several hundreds or thousands of times an hour, I need to set up an alert for when an hour goes by where any of them don't happen, and report on how many of the missing events were expected.
New event types will be added all the time without my knowledge, so it's not possible for me to provide a pre-populated lookup or anything.
So something like:
For each event type that occurred between -2h@h and -1h@h
Return each of those that did not also occur between -1h@h and 00h@h
And the count of those per hour over the last 6 hours
Thanks for any help
Randy
... View more