Close Menu
    Facebook X (Twitter) Instagram
    Monday, July 14
    X (Twitter) LinkedIn
    All about Endpoint Management
    • Home
    All about Endpoint Management
    Home»Collections»SCCM Collection for devices online with green checkmark

    SCCM Collection for devices online with green checkmark

    Eswar KonetiBy Eswar KonetiJanuary 21, 12:12 am1 Min Read Collections 10,047 Views
    Share
    Facebook Twitter LinkedIn Reddit

    This is quick blog post on how to create device collection for computers that are online and showing the green checkmark.

    When a configuration manager client is installed,it will have the following status code indicating the device. For more information about device client status, please refer here

    image

    How do we create a collection for clients that are online? 

    Collections uses WQL and following is the WQL syntax you can use to create the collection.

    we will use wmi class called SMS_CollectionMemberClientBaselineStatus which has the client online status information. This information comes from the client notification that uses BGB/fast channel.

    This collection uses sub-selected query.

    select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,
    SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System where SMS_R_System.ResourceId in
    (select resourceid from SMS_CollectionMemberClientBaselineStatus where SMS_CollectionMemberClientBaselineStatus.CNIsOnline = 1)

    image

    If your configuration manager is running on 2010, you will have option to preview the results. Click on the play button to see the results before you confirm the changes.

    image

    Save the collection and wait for few seconds before the data appear.

    image

    Based on the device collection membership, the results get updated.

    If you want to create a reports based on the online status, you can refer http://eskonr.com/2016/04/how-to-query-clients-collection-or-ssrs-ssrs-with-online-status-in-sccm-configmgr-1602/

    clientbaselinestatus Collection configmgr device online online devices SCCM SQL WQL
    Share. Twitter LinkedIn Email Facebook Reddit

    Related Posts

    SCCM SQL Report – Compare Installed Apps on TWO Different Computers

    July 13, 10:35 am

    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

    2 Comments

    1. Bob Hatcher on June 13, 2025 11:51 PM

      This one has driven me crazy for some time. Thank You so much. It works!

      Reply
    2. JB on March 17, 2022 12:21 PM

      Thank you, appreciate you taking the time to post this so it'd be here when I needed it!

      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.