January 11, 2011
HomeConfiguration ManagerDuplicate entries in add remove programs reports

Duplicate entries in add remove programs reports

By  Configuration Manager  4 Comments

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.

Related Posts

About Author

Jörgen Nilsson

4 Comments
  1. Filip

    Hi,

    Thanks for this tip!
    The reports now runs fine, however the report is used as a link in another report: Count of all instances of software registered with add or remove programs (report 95).

    If I run this report, then I still see the count of all isntances as well (in my case 418 times of office).
    If I drill down, then I arrive into the report which I modified with the distinct option and there I see the correct number of computers (34 unique computers).

    How I can modify report 95, so that i also filters out the duplicates?

    Many thanks!

    Filip

    Reply
  2. Manuel

    WOW! Thanks so much.
    A simple fix that really cleaned up my reports!

    Reply
  3. Mitesh Vasava

    Thanks very good advise

    Reply
  4. Bikash Biswal

    We have the same problem in our organization Add and remove program is showing duplicate entries for some systems. We tried through “Select distinct” whcih is not working.

    Could you please suggest to overcome this issue.

    Thanks in advance.

    Reply

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.