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)
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