Thursday, March 9, 2017

SCCM count of particular applications report

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

No comments:

Post a Comment