Close Menu
    Facebook X (Twitter) Instagram
    Tuesday, May 20
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»SCCM report display computers with IPaddress based on Application/software

    SCCM report display computers with IPaddress based on Application/software

    Eswar KonetiBy Eswar KonetiApril 01, 2:19 pm1 Min Read SCCM 2007 2,682 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Computers with specific application installed with IPaddress. Additional reports for Add and remove programs are available from http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/

    SELECT  a.Name0,b.IPAddress0,c.DisplayName0
    FROM
    v_GS_ADD_REMOVE_PROGRAMS c,
    v_R_System a,
    v_GS_NETWORK_ADAPTER_CONFIGUR b
    WHERE a.ResourceID = b.ResourceID and
    a.ResourceID=c.ResourceID and
    b.IPEnabled0='1' and b.ipaddress0 !='0.0.0.0'
    AND c.DisplayName0 like '%Adobe acrobat%'
    GROUP BY
    a.Name0,
    c.DisplayName0,
    b.IPAddress0
     
    ORDER BY a.name0

    If there are multiple computer entries,no worries bcz computer might have additional network connections which will have more than One IP which can be identified Via Resource Explorer—Hardware—>network adapter configuration

    Computers IP Address SCCM report display computers with IPaddress based on Application SCCM Reports SQL
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Monitoring Endpoint Security Applications with SCCM ConfigMgr SQL

    October 11, 8:48 pm

    Efficiently Identify Co-Managed Devices: Techniques and Tools

    January 17, 8:37 pm

    SCCM report list collections with no deployments

    December 05, 12:04 pm

    2 Comments

    1. srinivaschilukuri on January 11, 2012 1:16 PM

      Hi Eswar,

      This is srinivas from HYD.

      I need to get one report from SCCM for oracle installed machines with versions like Enterprise or standard.
      we are getting reports but not sure with versions please help me out.

      Reply
      • Eswar Koneti on January 11, 2012 1:26 PM

        Identify computer which has Oracle app installed and go to Resource Explorer from collection of that computer and look at add and remove programs if the version is displayed there.
        If you see the version avilable,it would be easy to create report for Version. If you dont see the version from add and remove programs,then you may have to try with exe file (software inventory).
        try the first Idea and see how it works.

        Reply

    Leave a ReplyCancel reply

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

    Sign Up

    Get email notifications for new posts.

    Author

    I’m Eswar Koneti ,a tech enthusiast, security advocate, and your guide to Microsoft Intune and Modern Device Management. My goal? To turn complex tech into actionable insights for a streamlined management experience. Let’s navigate this journey together!

    Support

    Awards

    Archives

    © Copyright 2009-2024 Eswar Koneti, All rights reserved.

    Type above and press Enter to search. Press Esc to cancel.