Reports have duplicates for every server

[Richard Layton_2]

Hello All,

I have attmepting to create a simple server inventory report that includes System Name, Product ID, and Serial Number. Now matter what I get i get duplicate information for each server.

Below is the SQL query that Insight used to create the report.

select R_Inventory.DeviceName, R_Inventory.ProductId, R_Inventory.SerialNumber from R_Inventory WHERE ((R_Inventory.SnapShotID=-1) OR (R_Inventory.SnapShotID is NULL)) AND DeviceKey=? order by R_Inventory.DeviceName ASC

Let me know if you have any ideas.

Thanks!

[Rob Buxton]

Do you have WBEM enabled globally with domain credentials.
I've seen this where WBEM data and the agent data doubles up.
I'm also seeing a similar issue on a hand crafted report with HPSIM SP5 where I'm now getting duplicate entries and I'm not sure what has changed there, and I don't have WBEM enabled for that server.
That started happening for me when I ditched our old HPSIM Database and installed a new HPSIM SP5 version.

[Richard Layton_2]

Yes WBEM is enabled in the global protocol settings. I'm monitoring some system that are not on our Domain so I have added account in there with multiple passwords for the admin accounts on the server.

[Joel Rubenstein]

Is this an upgrade from SIM 4.X?

[Richard Layton_2]

Yes, it is an upgraded system

[Joel Rubenstein]

The problem you encountered is a result of a database table entry that was not properly updated during the upgrade.

To fix the problem you need to run the following script in SQL query analyzer.
-------------------
Update DC_PolledData set preferredProto=8 where PollId=11
Update DC_PolledData set preferredProto=8 where PollId=12
Update DC_PolledData set preferredProto=8 where PollId=13
Update DC_PolledData set preferredProto=8 where PollId=14
Update DC_PolledData set preferredProto=8 where PollId=18
Update DC_PolledData set preferredProto=8 where PollId=19
Update DC_PolledData set preferredProto=8 where PollId=20
Update DC_PolledData set preferredProto=8 where PollId=21
Update DC_PolledData set preferredProto=8 where PollId=162
Update DC_PolledData set preferredProto=8 where PollId=193
Update DC_PolledData set preferredProto=8 where PollId=194
Update DC_PolledData set preferredProto=8 where PollId=195
Update DC_PolledData set preferredProto=8 where PollId=225
Update DC_PolledData set preferredProto=8 where PollId=226
Update DC_PolledData set preferredProto=8 where PollId=227
Update DC_PolledData set preferredProto=8 where PollId=228
Update DC_PolledData set preferredProto=8 where PollId=507
Update DC_PolledData set preferredProto=8 where PollId=580
Update DC_PolledData set preferredProto=8 where PollId=581
Update DC_PolledData set preferredProto=8 where PollId=582
Update DC_PolledData set preferredProto=8 where PollId=593
Update DC_PolledData set preferredProto=8 where PollId=594
Update DC_PolledData set preferredProto=8 where PollId=595
Update DC_PolledData set preferredProto=8 where PollId=703
Update DC_PolledData set preferredProto=8 where PollId=713
Update DC_PolledData set preferredProto=8 where PollId=2162
----------

Then restart the SIM service, run another data collection and the problem should be resolved.

[Richard Layton_2]

Well that helped some but about 90% of the report is still duplicating. When I ran the queries it said 1 row effected by each query.

[Joel Rubenstein · Accepted solution]

After modifying the database you need to restart the SIM service and then run a data collection on all servers.

[Richard Layton_2]

WOOHOO! That Did it!!

Thank You very Much!

[Richard Layton_2]

Thanks for your help. The info replies did the trick!