January 11, 2011
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.
To solve this just simply change the SQL Statement of both reports to use “Select Distinct” instead of only “Select”. See example below:
Run the report and the duplicate entries will not be shown anymore.
Using Windows 10 build numbers as Global Condition in ConfigMgr
Query to determine 32 or 64 bit Operating System
WSUS in Server 2012 and Supported SQL Server versions
About Author
Jörgen Nilsson
4 Comments
Add a Comment
This site uses Akismet to reduce spam. Learn how your comment data is processed.
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
WOW! Thanks so much.
A simple fix that really cleaned up my reports!
Thanks very good advise
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.