Version 1

    This report will show all the APC UPS's which have batteries which are at least 4 years old.

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

     

    ZIP contains SQL report.

    Zip also contains the UnDP for APCupsBasicBatteryLastReplaceDate which can be saved or the ''APCupsBasicBatteryLastReplaceDate' statment in the line "CustomPollers.UniqueName='APCupsBasicBatteryLastReplaceDate'" of the SQL can be changed to correspond with whatever you titled the UnDP (with OID 1.3.6.1.4.1.318.1.1.1.2.1.3) previously.

    If you would like to have the report check for a time different from 4 years, edit the lines following "CustomPollers.UniqueName='APCupsBasicBatteryLastReplaceDate'" (e.g. for batteries older than 3 years)

     

    AND 

    (

          year(getDate())-year(CustomPollerStatus.Status)>3 

      OR 

       (

          year(getDate())-year(CustomPollerStatus.Status)=3 

          AND 

          month(CustomPollerStatus.Status)-month(getDate())<0

       ) 

      OR  

       (

          year(getDate())-year(CustomPollerStatus.Status)=3 

         AND 

          month(CustomPollerStatus.Status)-month(getDate())=0

         AND 

          day(CustomPollerStatus.Status)-day(getDate())<1

       )

    )

     

     

    NOTE: For the UnDP/SQL Report to work correctly, each time the UPS Batteries are/have been replaced the replace date on the batteries must be reset.