HPE Community read-only access December 15, 2018
This is a maintenance upgrade. You will be able to read articles and posts, but not post or reply.
Hours:
Dec 15, 4:00 am to 10:00 am UTC
Dec 14, 10:00 pm CST to Dec 15, 4:00 am CST
Dec 14, 8:00 pm PST to Dec 15, 2:00 am PST
Server Management - Systems Insight Manager
cancel
Showing results for 
Search instead for 
Did you mean: 

Reports have duplicates for every server

 
SOLVED
Go to solution
Richard Layton_2
Frequent Advisor

Reports have duplicates for every server

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!
9 REPLIES
Rob Buxton
Honored Contributor

Re: Reports have duplicates for every server

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
Frequent Advisor

Re: Reports have duplicates for every server

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
Honored Contributor

Re: Reports have duplicates for every server

Is this an upgrade from SIM 4.X?
Richard Layton_2
Frequent Advisor

Re: Reports have duplicates for every server

Yes, it is an upgraded system
Joel Rubenstein
Honored Contributor

Re: Reports have duplicates for every server

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
Frequent Advisor

Re: Reports have duplicates for every server

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
Honored Contributor
Solution

Re: Reports have duplicates for every server

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

Re: Reports have duplicates for every server

WOOHOO! That Did it!!

Thank You very Much!
Richard Layton_2
Frequent Advisor

Re: Reports have duplicates for every server

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