Close Menu
    Sunday, November 24

    SCCM report list all the computers with application installed

    Eswar KonetiBy 1 Min Read SCCM 2007 6,061 Views

    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

    Share.

    Related Posts

    2 Comments

      • Eswar Koneti on

        yes,it is possible to get user for the computer and can get it from v_r_system or v_r_user.

        Thanks
        Eswar

        Reply

    Leave a Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.