I have an event stream which contains the values for some variables. The values change every second. Each variable has high limit, low limit and a threshold period defined.
For example, say Variable1 has high limit = 95, low limit = 5 and threshold = 5 seconds.
So if the values for Variable1 stay above 95 (high limit) for the threshold period (5 seconds), then we should create an output event.
I am able to create query for checking the individual events (if they have crossed the limits), but I am not sure how to create a windowed query to check if the limits were violated for the threshold period.
LinqPad. Next, download the StreamInsight samples and enable the StreamInsight driver for LinqPad.
In the StreamInsight samples, you'll find "Alarm Floods and Transients" under "Query Patterns". This set of queries will do exactly what you are trying to do. And ... once you get LinqPad and the samples installed, you'll have a TON of other queries and
query pattern examples.
DevBiker (aka J Sawyer) My Blog My Bike - Concours 14 If I answered your question, please mark as answer.
If my post was helpful, please mark as helpful.