Close Menu
    Facebook X (Twitter) Instagram
    Thursday, October 22
    X (Twitter) LinkedIn Reddit RSS
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Collections»collection to get list of systems that doesnt have specific application installed

    collection to get list of systems that doesnt have specific application installed

    Eswar KonetiBy Eswar KonetiMarch 19, 20101 Min Read Collections
    Share
    Facebook Twitter LinkedIn Reddit

    There might be the scenario where you will be looking for computers which doesnt have particular application installed on.Create a new collection and copy the below  simple WQL query which list you all computers there by you can advertise the application package onto it.

    select SMS_G_System_SYSTEM.Name from  SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.Name not in (select SMS_G_System_SYSTEM.Name from  SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName like “Adobe acrobat reader“)

    change the application(adobe actobat reader) the one you are looking at.

    Collections
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM report list collections with no deployments

    December 5, 2022

    Investigating SCCM Client Policy Request and Communication Status with a Collection Specific Report

    October 15, 2022

    SCCM Collection for AAD joined devices (co-managed)

    February 5, 2021
    Leave A Reply Cancel Reply

    Support

    Awards

    Archives
    • Home

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

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