4 Replies Latest reply on Jun 24, 2016 1:15 PM by janene16

    Report Writer: APC UPS Battery Date Comparison

    bill.h

      The goal: Create a report that will show APC UPS's with a battery date older than 3 years.

       

      Why: We would like to keep track of aging equipment and be able to see which UPS's should have their battery replaced before the battery replace indicator goes off.

       

      I am currently using Universal Device Polling to get the "upsBasicBatteryLastReplaceDate" field on a report, which shows up in this format: mm/dd/yy

       

      Does anyone know of a way to compare this field to the current date and filter to ONLY show batteries that are older than 3 years?

       

       

      I would also be interested in doing the same thing with the manufacturer date, to get a report of replacing the entire unit after 6 years. But if the above problem is solved, it would be trivial to apply the same idea to this one too.