SCCM Report - Count of all instances of software registered with Add or Remove Programs

Mo_Khimani
Mo_Khimani used Ask the Experts™
on
Hi. Using SCCM to run a report of "Count of all instances of software registered with Add or Remove Programs, I get a report that is counting instances several times for an individual machine. This gives figures for instances of software 4, 5, 6, 7 or more times than the reality.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Clone the report "Count of all instances of software registered with Add or Remove Programs", and modify the SQL 'Count(*)' to 'Count(Distinct arp.ResourceID)' (As per below).

I haven't determined why yet, but there ARE actuall mutliple entereis in the database per machine for some software installs (Like Office 2007 SP2)



SELECT DisplayName0, Count(Distinct arp.ResourceID) AS 'Count', Publisher0, Version0, @CollID as CollectionID
FROM v_Add_Remove_Programs arp
JOIN v_FullCollectionMembership fcm on arp.ResourceID=fcm.ResourceID
WHERE fcm.CollectionID = @CollID
GROUP BY DisplayName0, Publisher0, Version0
ORDER BY Publisher0, Version0

Author

Commented:
You're a Top Man Jon! The results now are much more accurate reflection of what's installed on workstations. It will now be interesting to compare what else was also being multi-counted.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial