topic Re: Reports have duplicates for every server in Server Management - Systems Insight Manager

Reports have duplicates for every server

Richard Layton_2 — Tue, 12 Sep 2006 15:12:26 GMT

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!

Re: Reports have duplicates for every server

Rob Buxton — Tue, 12 Sep 2006 15:25:40 GMT

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.

Re: Reports have duplicates for every server

Richard Layton_2 — Wed, 13 Sep 2006 07:34:26 GMT

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.

Re: Reports have duplicates for every server

Joel Rubenstein — Wed, 13 Sep 2006 07:55:06 GMT

Is this an upgrade from SIM 4.X?

Re: Reports have duplicates for every server

Richard Layton_2 — Wed, 13 Sep 2006 08:01:25 GMT

Yes, it is an upgraded system

Re: Reports have duplicates for every server

Joel Rubenstein — Wed, 13 Sep 2006 08:15:58 GMT

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.

Re: Reports have duplicates for every server

Richard Layton_2 — Wed, 13 Sep 2006 08:50:18 GMT

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.

Re: Reports have duplicates for every server

Joel Rubenstein — Wed, 13 Sep 2006 09:00:24 GMT

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