Custom Reporting

What's the OID for that?

One thing to bear in mind is that the APC UPS devices don't, as far as I am aware, automatically update this field when you replace a battery - it is up to an administrator to do this.

But to go back to your question, if you can get the OID returned as a date type, you would need to do a report based on custom SQL where you end up with a test for something like:

WHERE DATEADD(year, 4, APCupsBasicBatteryReplaceDate) < SYSDATETIME()

(Please note that is not necessarily going to work out of the box... You may need to do a fair bit of work to transform the OID return value into soemthing you can compare to SYSTIMEDATE()!)

Is their a way to see the SQL statements from the Alert Manager variables .