The Hardware Inventory Search report displays duplicate entries for every computer

Article:HOWTO10733  |  Created: 2009-10-14  |  Updated: 2012-07-21  |  Article URL http://www.symantec.com/docs/HOWTO10733
Article Type
How To



Problem
The Hardware Inventory Search report displays duplicate entries for every computer.

This report is under Reports > Discovery and Inventory > Inventory > Cross-platform > Hardware.

Each of the duplicates have identical entries in all fields.

Environment
SMP7 SP2 HF2

Altiris Inventory Solution SP1

Altiris Client Management Suite 7.0.9

Cause
Unknown, we were unable to duplicate this in our lab.

Resolution
I made a clone of the report and it returned the same double entries.
I was able to modify the clone's SQL by adding "DISTINCT" after the "SELECT" statement and the clone now returns only one row per computer.

The default query reads (in part):

DECLARE @v1_TrusteeScope nvarchar(max)
SET @v1_TrusteeScope = N'%TrusteeScope%'
SELECT i.Guid,
i.Name [Computer Name],

I changed it to read:

DECLARE @v1_TrusteeScope nvarchar(max)
SET @v1_TrusteeScope = N'%TrusteeScope%'
SELECT DISTINCT i.Guid,
i.Name [Computer Name],


Legacy ID



49655


Article URL http://www.symantec.com/docs/HOWTO10733


Terms of use for this information are found in Legal Notices