Query:
select
DisplayName0,
Version0,
Count (Distinct arp.ResourceID)
From
dbo.v_Add_Remove_Programs ARP
Where
DisplayName0 Like ('%A%') or
DisplayName0 Like ('%B%') or
DisplayName0 Like ('%C%')
Group by
DisplayName0,
Version0
Order by
DisplayName0,
Version0
select
DisplayName0,
Version0,
Count (Distinct arp.ResourceID)
From
dbo.v_Add_Remove_Programs ARP
Where
DisplayName0 Like ('%A%') or
DisplayName0 Like ('%B%') or
DisplayName0 Like ('%C%')
Group by
DisplayName0,
Version0
Order by
DisplayName0,
Version0
No comments:
Post a Comment