How can I get these power information in SIM report?

[simon yuan]

Hi all,
I'm trying to generate a report that will show the PowerSupply information of my servers.The SIm report including these grids:

DeviceName
ModelName
SerialNumber
ConditionVal
MaxCapacity
UsedCapacity
Status
Type
PhysicalLocation
Manufacturer
and so on...

but there are no data in a lot of grids.Just like the sample report which is attached(SIM5.3).

So, if I want to get the usuful Power information,such as SerialNumber\MaxCapacity\UsedCapacity,what can I do?
Thanks!

[NJK-Work]

You should be able to (or have a DBA) write a custom query using your favorite reporting tool (Access, Crstal Reports, even built-in SQL server tools) to get the information you want. For example, I wanted to get a count of total powers supplies in each server, so I wrote this:

SELECT TOP 100 PERCENT dbo.devices.DeviceKey, dbo.devices.Name AS ServerName, COUNT(dbo.devices.Name) AS PSCount
FROM dbo.devices INNER JOIN
dbo.CIM_PowerSupply ON dbo.devices.DeviceKey = dbo.CIM_PowerSupply.NodeID
WHERE (dbo.devices.ProductType = 1)
GROUP BY dbo.devices.DeviceKey, dbo.devices.Name
ORDER BY dbo.devices.Name

Nelson