Adobe Dashboard

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)