topic Re: HP Insight Manager SQL request in Server Management - Systems Insight Manager

HP Insight Manager SQL request

zajac — Tue, 18 Mar 2008 14:15:23 GMT

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 ?

Re: HP Insight Manager SQL request

NJK-Work — Tue, 18 Mar 2008 15:37:31 GMT

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

Re: HP Insight Manager SQL request

zajac — Wed, 19 Mar 2008 08:27:22 GMT

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.

Re: HP Insight Manager SQL request

NJK-Work — Wed, 19 Mar 2008 20:33:59 GMT

Glad to help.

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

Nelson

Re: HP Insight Manager SQL request

zajac — Thu, 20 Mar 2008 07:54:50 GMT

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

Re: HP Insight Manager SQL request

V Deepak Kumar — Thu, 20 Mar 2008 11:25:44 GMT

This information is rendered via SNMP data on the server.

Re: HP Insight Manager SQL request

Change_happens — Thu, 20 Mar 2008 12:01:15 GMT

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

Re: HP Insight Manager SQL request

zajac — Thu, 20 Mar 2008 12:31:41 GMT

sql request was clean.