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
Selectleft(DisplayName0,14),count(distinct ResourceID) as 'client count'
fromdbo.v_ADD_REMOVE_PROGRAMS ARPwhereARP.DisplayName0 like 'Adobe Reader%'
group byleft(DisplayName0,14)order byleft(DisplayName0,14)