i Set Up Report to View Cisco Devices without Redundant Power

Hi All, 

We have several cisco devices & we wanted to check to see how many are without a redundant power supply unit. Is there a method to generate a power supply report to see which ones do not have two power supplies or maybe even ones that do have two power supplies and have some sort of failure message, etc.?