Problem with Netware CPU information in reports

[NJK-Work]

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