Close Menu
    Sunday, July 5

    SCCM report list all the computers with application installed

    Eswar KonetiBy 1 Min Read SCCM 2007

    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

    4 Comments

    1. Leo on

      I am struggling to combine these two queries so that I can get a list of computer models and the installed wireless driver on it.
      Any help would be great. Thanks.

      SELECT
      Model0 AS Model,
      COUNT(*) AS Count
      FROM
      v_GS_COMPUTER_SYSTEM
      GROUP BY Model0

      select count(name0),Name0 from v_GS_NETWORK_ADAPTER where
      v_GS_NETWORK_ADAPTER.Description0 like '%Wireless%'
      group by Name0

      Reply
      • Eswar Koneti on

        Hi Leo,
        apologies for the delay. here is the combined SQL query.

        SELECT
        Model0 AS Model,
        COUNT(*) AS Count
        FROM
        v_GS_COMPUTER_SYSTEM cs
        inner join v_GS_NETWORK_ADAPTER na on na.ResourceID=cs.ResourceID
        where na.Description0 like '%Wireless%'
        GROUP BY Model0

        thanks,
        Eswar
        http://www.eskonr.com

        Reply
      • 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