Duplicate entries in add remove programs reports

This is a very annoying but really easy to fix feature of two reports in Configuration Manager 2007, the two reports used to report on software registered in Add/Remove Programs on clients:

  • Computers with specific software registered in Add Remove Programs (nr 92)
  • Software registered in Add Remove Programs on a specific computer (nr 93)

Shows duplicates of some of the software titles installed on the computer, as shown in the example below.

addremove93

To solve this just simply change the SQL Statement of both reports to use “Select Distinct” instead of only “Select”. See example below:
report2

Run the report and the duplicate entries will not be shown anymore.

4 Comments

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.