How to create report for Hardware health - to get power supply for all swiches? The hardware health we can see in the node summary page.
You need to create a custom table report and use the following as your starting point:
SELECT NodeID ,ParentObjectID ,ParentObjectName ,ParentObjectStatus ,ParentObjectVendor ,PollingMethod ,Manufacturer ,Model ,ServiceTag ,IsDisabled ,CategoriesWithProblems ,CategoriesWithStatus ,StatusDescription ,DescriptionFROM Orion.HardwareHealth.HardwareInfo
If you have multiple vendors then you may also need to go down the road of creating UnDPs to identify PSUs for the non-SolarWinds default vendors - basically Cisco and Juniper) are the rest aren't.
