No CPU Data for Netware servers

[Bill Slobodnik]

Data Collection is not reporting any CPU data for Netware 4.x and 6.5 servers using proliant G2's, G3's, and G4's. All other info is picked up by data collection. Web agents on these servers do show the CPU data, but Data Collection info is needed for inventory reporting.
Any idea's on how this can be resolved?

[Bill Slobodnik]

I see this question has been posted several times previously w/o any responses.
Is this a known issue or is there any documented resolution?

[Bill Slobodnik]

Update: I opened a case with HP. I'll post any relevant info I receive.

[NJK-Work · Accepted solution]

Here is my previous post on the subject:

Hello,

In the past, there has been a few threads (including one from me) regarding the built in reports in SIM 4/5 not showing CPU information for Netware servers.

It appears there are two tables in SIM (at least my implementation):

CIM_Processor (Missing Netware CPU info)
DB_DeviceCPU (Seems to have all correct CPU information)

From what I can tell, the reports in SIM go off the bad CIM_Processor table and thus do not show CPU information for Netware servers.

If you create the following view (using SQL Enterprise Manager) you can simulate what the CIM_Processor table would give you with the exception of some columns, but at least includes the Netware CPU information:

SELECT TOP 100 PERCENT dbo.devices.DeviceKey, dbo.devices.Name AS [Server Name], dbo.DB_DeviceCpu.CpuSpeed AS CurrentClockSpeed,
dbo.DB_DeviceCpu.CpuIndex AS OtherIdentifyingInfo, 'CPU' + STR(dbo.DB_DeviceCpu.CpuIndex, 1, 0) AS DeviceID,
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.Name

So if you want to create your own report that actually shows the Netware CPU information, you can create the above custom view and then build a report against it.

Hope this helps. I was struggling with this for a while, and then I just happened to stumble on the other table and sure enough it had the Netware information it in.

Nelson

[David Claypool]

Nelson or Bill, if that is the case, report it and get a case number and send that case number to me and we'll get it to the dev team to handle and correct on a future release.

[Bill Slobodnik]

David, I have a case number currently open, #3215509493.

Nelson, creating that view worked. I was able to pull CPU data for all servers.

Thank you both!

[David Claypool]

Thanks, Bill, I forwarded it to software QA.

[NJK-Work]

You are welcome!
Nelson

[Gutschke, Reiner]

Hi,
We have the same problems and opened a case #1212476995.
We have this problem on all Proliant-Servers from typ 3000 to ML/DL xxx G1/G2/G3/G4 with various PSP's and Netware 5.x/6.x since we changed from CIM7 to SIM.

The only Server with no Problem is a Netware 3.12-Server on a Proliant3000 with PSP 3.60.

Reiner

[Gutschke, Reiner]

Hi Bill,
here the first reaction from second level:

"data collection report does not support cpu details for novell netware machines"

This is unacceptable! With the prior Tool CIM7 there was no problem.

What about your case? Any news?

Reiner

[Bill Slobodnik]

See Nelson's reply above. His solution worked in that the data is on the database, only on a different table that the HPSIM app does not pull from. In other words, I could create the report through the database, but not HPSIM.
In regards to the case, the last update I recieved was that development recognized the issue and would incorporate the necessary changes in a future release.

[Sagar Progen]

was just checking the error , i also find this , hey the above workaround works

[Gutschke, Reiner]

David,
i heard HP guess that the initial reason for the problem ought to be the SNMP Stack on Netware side.
Following the above discussion (no problems with CIM7, Data are in SIM Database, but in a "wrong" table) I don't understand this direction of thoughts.
Can you explain this?
Thanks!