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.