The Hardware Inventory Search report displays duplicate entries for every computer

book

Article ID: 178483

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

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],