I've received a request to monitor for and create an alert if a service bounces more than a certain number of times in a given period (say, 3 times in a week, for example).
Is there a way to do this, and if so, how?
In theory this could be accomplished using a SQL alert triggered on events. I would be cautious however about how frequently that condition is checked, as this could be a large amount of data to query depending on how many events are generated per hour/day and how large of window of time you wanted to use.
I don't think we would need frequent checks, but the time frames may be long (we may want to know, for example, if a particular service bounced >=3 times in 14 days.
I'm not a SQL guy at all. Any idea where to start on this? Would a report be a better way to go?
I would recommend asking the folks in the Alert Lab. A report would be far simpler approach, but you don't have the benefit of being notified when the condition occurs, rather you would find out only by reading the report.
I tried that (Alert if condition occurs X times in Y minutes (on same device)) and got no replies.
