- Community Home
- >
- Servers and Operating Systems
- >
- HPE ProLiant
- >
- Server Management - Systems Insight Manager
- >
- Re: Reports have duplicates for every server
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2006 08:12 AM
тАО09-12-2006 08:12 AM
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2006 08:25 AM
тАО09-12-2006 08:25 AM
Re: Reports have duplicates for every server
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2006 12:34 AM
тАО09-13-2006 12:34 AM
Re: Reports have duplicates for every server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2006 12:55 AM
тАО09-13-2006 12:55 AM
Re: Reports have duplicates for every server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2006 01:01 AM
тАО09-13-2006 01:01 AM
Re: Reports have duplicates for every server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2006 01:15 AM
тАО09-13-2006 01:15 AM
Re: Reports have duplicates for every server
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2006 01:50 AM
тАО09-13-2006 01:50 AM
Re: Reports have duplicates for every server
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2006 02:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2006 02:19 AM
тАО09-13-2006 02:19 AM
Re: Reports have duplicates for every server
Thank You very Much!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2006 02:39 AM
тАО09-13-2006 02:39 AM