Close Menu
    Facebook X (Twitter) Instagram
    Monday, June 23
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Collections»SCCM collection Subselected Queries

    SCCM collection Subselected Queries

    Eswar KonetiBy Eswar KonetiDecember 02, 11:58 am2 Mins Read Collections 4,240 Views
    Share
    Facebook Twitter LinkedIn Reddit

    Have seen lot of questions on how to get list of computers that do not have xxxxxx .This xxxx could be of anything like softwares,file names anything that do not have.

    In this post,I will go through step by step procedure how to make it simple.

    Step 1: To get list of computers that do not have xxxx,create a collection query that has xxxx. I think this is pretty much easy how to do it using criteria.

    Create new collection and edit the query .

    Click on Criteria Tab , click Yellow Burst

    In the Criterion properties page, click on select

    select attribute class and attribute which you want ( here i go with add and remove programs)

     

    select the display name which you like xxxxx .I go with Adobe Acrobat .Why i used % is ,it list all computers that contains word like Adobe Acrobat.

    Now Click on Show query Language to get the WQL code:

    Here is the code we have got that list all computers with particular software installed :

    select *  from  SMS_R_System 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%"

    so cut the query and paste it in notepad we need this again.You will see blank query now.

    Step 2: In this step,we will create collection with subselected criteria to get what we need .

    Click on the Yellow Burst once again and select criterian type as "Subselected Values" and click on select

     

     

    and select the operator as not in and past the query which you copied earlier into it.

     

    query which we created earlier is :

    select *  from  SMS_R_System 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%"

    Replace * with SMS_R_System.ResourceID in your qeury and click on Ok.

    You can also filter the above collection to look only for windows 7 computer i.e OS version 6.1 etc .

    Collections configmgr Microsoft SCCM Reouce ID Not in SCCM Sub functions Sub selected Quiries Subselected Subselection quiry System center configuration Manager
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    Optimize Your Intune Workflow with a Powerful Browser Extension

    March 22, 10:39 am

    Migrate Microsoft 365 Updates from SCCM/MECM to Intune for Co-Managed Devices

    February 11, 9:50 pm

    Investigating Co-Management Issues with Windows Endpoints in SCCM/Intune

    October 26, 10:45 pm

    2 Comments

    1. FRACNSCI on May 27, 2020 12:41 AM

      Hi Eswa

      how to get a list of computer with office, adobe, visio and project, installed on it
      i mean i have an environment i with several version of office such as 2010,2013 and 2016 same situation for adobe and visio and project.

      how can achieve this?

      Reply
      • Eswar Koneti on May 28, 2020 2:45 AM

        Hi,
        you want to create a collection or report that list the devices with office & adobe & visio & project installed? (This is AND meaning, all these apps must exist on the device)?

        Thanks,
        Eswar

        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.

     

    Loading Comments...