OWSUG.ca

For full details see forum post http://social.technet.microsoft.com/Forums/en-US/configmgrsdk/thread/8d8cabc9-5b7b-477b-8443-c6c2abae64c2/#4b6c6e69-adee-4f6b-b51d-da941d1dcf41

Select
	left(DisplayName0,14),
	count(distinct ResourceID) as 'client count'
from 
	dbo.v_ADD_REMOVE_PROGRAMS ARP
where 
	ARP.DisplayName0  like 'Adobe Reader%'
group by 
	left(DisplayName0,14)
order by 
	left(DisplayName0,14)