topic Re: No CPU Data for Netware servers in Server Management - Systems Insight Manager

No CPU Data for Netware servers

Bill Slobodnik — Wed, 12 Jul 2006 15:41:11 GMT

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?

Re: No CPU Data for Netware servers

Bill Slobodnik — Thu, 13 Jul 2006 15:26:16 GMT

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?

Re: No CPU Data for Netware servers

Bill Slobodnik — Fri, 14 Jul 2006 14:38:59 GMT

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

Re: No CPU Data for Netware servers

NJK-Work — Mon, 24 Jul 2006 12:53:13 GMT

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

Re: No CPU Data for Netware servers

David Claypool — Mon, 24 Jul 2006 13:09:32 GMT

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.

Re: No CPU Data for Netware servers

Bill Slobodnik — Mon, 24 Jul 2006 13:17:01 GMT

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!

Re: No CPU Data for Netware servers

David Claypool — Mon, 24 Jul 2006 14:17:16 GMT

Thanks, Bill, I forwarded it to software QA.

Re: No CPU Data for Netware servers

NJK-Work — Wed, 26 Jul 2006 11:50:50 GMT

You are welcome!
Nelson

Re: No CPU Data for Netware servers

Gutschke, Reiner — Fri, 08 Sep 2006 06:10:39 GMT

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

Re: No CPU Data for Netware servers

Gutschke, Reiner — Thu, 14 Sep 2006 06:11:30 GMT

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

Re: No CPU Data for Netware servers

Bill Slobodnik — Fri, 15 Sep 2006 09:25:11 GMT

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.

Re: No CPU Data for Netware servers

Sagar Progen — Tue, 19 Sep 2006 11:01:25 GMT

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

Re: No CPU Data for Netware servers

Gutschke, Reiner — Tue, 10 Oct 2006 03:37:54 GMT

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!