SIM Data Collection is useless

[Jeff Cottrill_1]

Redundant records and information being stored in the wrong fields have rendered HPSIM pretty much useless in our environment, preventing us from upgrading our current CIM7 server. Here are some examples:

IN the R_OperatingSystem view (and in the CIM_OperatingSystem table it pulls from), many of my servers appear twice with different information in the SubDesc field. In one entry, this field contains the Service Pack, build, and uni/multiprocessor designation. In others, it contains the description we've assigned. The CIM7 R_OperatingSystem table consistenly listed only the Service Pack info. In the R_ArrayControllers view, each server has two separate records for each controller. One entry lists BoardName correctly, and Model is , the second lists BoardName , and Model correctly. Again, the CIM7 R_ArrayControllers view correctly lists one entry per array controller per server. The R_CPU view is the worst. I have several dual processor servers that have 6 separate records. The CIM7 R_CPU table correctly lists one record per processor per server.

I am fairly certain that this is all due to the fact that SIM is using multiple protocols for the data collection tasks, and that each protocol is seeing the same information slightly differently, resulting in unique records. This needs to be fixed, as the data obtained from the canned reports, as well as what we're trying to extract into other databases, is now totally unreliable.

Is anyone at HP looking into this?

[Rob Buxton]

Tend to agree it's gone backwards. There were some other threads on the R-Tables a few weeks ago.

I've sorted out many of the duplicates by reducing the protocols and deleting and rediscovering servers.
I found that new Servers that were initially built as Workgroup, discovered by HPSIm and then added to the domain also had duplicate entries.

I've got the tables clean but lost some historical data.
CIM 7 seemed to regenerate the R_ tables, HPSIM does not seem to follow the same process.

[Jeff Cottrill_1]

I've removed everything from SIM (its still in "lab mode") and enabled just snmp. that clears up most of the duplication on the devices that I add back in, but the Array Controller info is still duplicated. There may be others, but I've not dug into everything yet. WBEM is the biggest culprit for the duplicate & junk data that I get.