How can I get these power information in SIM report?

simon yuan — Wed, 08 Apr 2009 09:16:30 GMT

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!

Re: How can I get these power information in SIM report?

NJK-Work — Mon, 13 Apr 2009 15:25:14 GMT

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

topic How can I get these power information in SIM report? in Server Management - Systems Insight Manager

How can I get these power information in SIM report?

Re: How can I get these power information in SIM report?