SCCM report list all the computers with application installed

SELECT
c.Name0,
a.DisplayName0

FROM
v_GS_ADD_REMOVE_PROGRAMS a,
v_R_System c

WHERE a.ResourceID = c.ResourceID
AND a.DisplayName0 like ‘%Adobe acrobat%‘

GROUP BY
c.Name0,
a.DisplayName0

ORDER BY c.name0

Leave a Reply