Is it possible to compare current component value with previous?

I have a wmi component, let it be "Queue Length" with 3 min poll interval.
And I have a threshold for it "Length>500". So every time it cross a threshold line, I get an email.

I want to make other alert to see a dynamic/trend of the queue length.
It must be like "if current queue length is bigger than 3 minutes ago - send an email".

Find more posts tagged with

sam

components

variables

Accepted answers

All comments

frak

What you need to do is setup an alert by SQL/SWQL, against the Component.

With this you can reference the historical component values, and compare them to the current value.

omavel

But how can I get previous component statistic data with swql?

sum_giais

Comparing the current value with the previous value is a bit complicated. Although if you know where the data is in the database yeah it’s possible. I’ve done this with UnDP’s before but there’s no easy native way to do that with either SWQL or SQL. It involves getting the current value and then doing a datediff of some sort to pull in the older value with various joins to pull those values in.

That said, there may be an easy way to accommodate this by making the component threshold a count as difference and alert on the status that way and make it be like 2 out of 3 etc.

frak

I would write up some code, but currently don't have access to an install to do it in.