HP Insight Manager SQL request

[zajac]

Hi,

Is there someone who know how to get the number of physical processors by server using HP System Insight Manager SQL database.

It seems just to store informations about logical processors.

Any idea ?

[NJK-Work · Accepted solution]

I believe it actually is physical. I think they just use the term "logical".

This query will get you all the CPUs:

SELECT TOP 100 PERCENT dbo.devices.DeviceKey, dbo.DB_DeviceCpu.CpuSpeed, dbo.DB_DeviceCpu.CpuIndex AS SlotNumber,
'CPU' + STR(dbo.DB_DeviceCpu.CpuIndex, 2, 0) AS Instance, STR(dbo.DB_DeviceCpu.DeviceKey, 5, 0) + STR(dbo.DB_DeviceCpu.CpuIndex, 1, 0)
AS Processor_LUID, dbo.DB_DeviceCpu.CpuName AS Name
FROM dbo.DB_DeviceCpu INNER JOIN
dbo.devices ON dbo.DB_DeviceCpu.DeviceKey = dbo.devices.DeviceKey
ORDER BY dbo.devices.DeviceKey, dbo.devices.Name

If you pump the results of the above to a table, lets call it MyCorp_CPU, and then run this, it should give you a count of each:

SELECT DeviceKey, COUNT(CPUSpeed) AS Processors
FROM dbo.MyCorp_CPU
GROUP BY DeviceKey

You just have to link up the DeviceKey back to a server name to make the results meaningful.

Nelson

[zajac]

thank you it's perfect for my job.

but i'm still sure that in HP SIM console and HP HomePage, we can't see physical one but just logical.

[NJK-Work]

Glad to help.

Where is it that you see "logical" used for the terminology?

Nelson

[zajac]

under permofance/Utilization on the system page in HP SIM

There's a menu Processor
for example

Processor Index Type Utilization (%)
0 1866 MHz Intel Xeon 0
1 1866 MHz Intel Xeon 0
2 1866 MHz Intel Xeon 0
3 1866 MHz Intel Xeon 0

[V Deepak Kumar]

This information is rendered via SNMP data on the server.

[Change_happens]

Yes zajac,
this is physical ones but yes not accurate as these data coming through SNMP directly from server.

[zajac]

sql request was clean.