Close Menu
    Facebook X (Twitter) Instagram
    Sunday, October 12
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»SCCM 2007»sccm report for computers doesnt have software installed

    sccm report for computers doesnt have software installed

    Eswar KonetiBy Eswar KonetiFebruary 21, 10:48 am1 Min Read SCCM 2007 4,578 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Create a new report and paste the following query into it.This needs prompt as well to list the applications installed on computers .

    Select Distinct
    sys.Netbios_Name0,
    sys.User_Domain0,
    sys.User_Name0
    FROM
    v_R_System sys
    JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
    WHERE
    sys.ResourceID not in (select sys.ResourceID
    from
    v_R_System sys
    JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
    where
    DisplayName0 = @displayname)

    Prompt for Displayname:

    select DisplayName0 from v_Add_Remove_Programs

    You can also filter this to collection ,see how this can be done from http://eskonr.com/2010/01/sccm-report-for-applications-installled-on-computers-with-without/

    Computers sccm report sccm report for computers doesnt have software installed SCCM report for software not installed software SQL
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    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

    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-2025 Eswar Koneti, All rights reserved.

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