Alert on "date" more than "60 months"

FormerMember

Hi folks,

most of my APC UPS nodes have a battery instalation date, APC recomends that batteries over 60 months have to be checked. I need to be alerted when the instalation date is older than 60 months.

I have setup a custom poller that retrieves the date ok

I have setup an alert using a test date of 01/01/2008 that has a trigger like...

----------------------------------

"Vendor" is equal to "American Power Conversion Corp."

"Poller name" is equal to "upsBasicBatteryLastReplaceDate"

"Status" is less than "01/01/2008' 

-----------------------------------

Now this doesn't trigger an alert and must be something to do with the less than statement. I can confirm the date received by the custom poller is 16/02/2005".

My main issue however is that I don't want to change the date every day, I want something that reads like....

"Status" of "upsBasicBatteryLastReplaceDate" is more than "60 months"

can anyone help or think of a better method?

thanks

Dave

qle

You would definitely have a need for a custom SQL statement here but I don't know if it's permitted in trigger conditions.