Menu
CCMEXEC.COM – Enterprise Mobility
  • Home
  • General
  • Configuration Manager
  • Windows 10
  • Intune
  • GitHub
  • Windows 11
  • About the author
CCMEXEC.COM – Enterprise Mobility

Duplicate entries in add remove programs reports

Posted on January 11, 2011 by Jörgen Nilsson

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 thoughts on “Duplicate entries in add remove programs reports”

  1. Filip says:
    November 21, 2011 at 9:22 am

    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 says:
    January 5, 2012 at 9:53 pm

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

    Reply
  3. Mitesh Vasava says:
    June 21, 2012 at 11:59 am

    Thanks very good advise

    Reply
  4. Bikash Biswal says:
    November 8, 2016 at 10:20 am

    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

Leave a Reply Cancel reply

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.

My name is Jörgen Nilsson and I work as a Senior Consultant at Onevinn in Malmö, Sweden. This is my blog where I will share tips and stuff for my own and everyone elses use on Enterprise Mobility and Windows related topics.
All code is provided "AS-IS" with no warranties.

Recent Posts

  • Community tools demoed at WPNinjas 2023
  • PowerShell script to keep Personal Teams away in Windows 11
  • Windows 11 Multi-App kiosk – a first look
  • Playing around with Driver Updates in Intune
  • MMUGSE – Summer Meetup 8th of June 2023

©2023 CCMEXEC.COM – Enterprise Mobility | WordPress Theme by Superb Themes
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish.Accept Reject Read More
Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Non-necessary
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
SAVE & ACCEPT