SCCM 1602 Query – All Online Machines

Quickpost: SCCM 1602 Query – All Online Machines

With the Advent of client activity indicators in SCCM 1606:


We can now see which machines are online at a given time.  I love these green checkboxes.

I thought it would be cool to try to make a collection of only currently online machines.  So, into the query editor we go!  We’ll add a new query rule, and then use the wizard to add a new value.  This is all that you need to grab only the currently online systems.


This collection works VERY well for Incremental Updates.  However, Scheduled Updates don’t make much sense

And the end result:

They’re all online!  So green!



6 thoughts on “SCCM 1602 Query – All Online Machines

  1. skatterbrainzz June 24, 2016 / 7:20 pm

    That was my one suggestion via UserVoice that was accepted and completed. I saw the data in sql tables and thought it might be useful. I can take a nap now. 🙂

  2. ersatyle August 10, 2016 / 9:47 am

    hi, if I’m using this query I don’t see only “online” (ie computers that are started/pingable right now or in the last 5min) but active computer (according to heartbeat/inventory … as per
    so it’s not all green for me.

    what am I missing?
    so far the I’m using a search criteria in the console to display only online computers.

  3. Steve October 25, 2017 / 2:37 pm

    The title says Online systems which means you would have to use the “Device Online Status” not the “Client Activity” property to show which systems are actually online. Unfortunately, the Device Online Status” is not inventoried or a property of the DDR so you can’t easily make a collection that shows you the Online systems.

Have a code issue? Share your code by going to and pasting your code there, then post the link here!

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s