If you would like to create a SCCM computer collection that includes only active, or only inactive computers then you will want to read this step-by-step guide.
I couldn’t find anywhere on the Internet that showed how to do this, so here’s how I created a collection of all of our ‘Active’ computers:
Under Assets and Compliance -> Device Collections, create a new device collection.
On the ‘General’ tab, fill in the name of the collection, a comment if you are feeling funky and set the limiting collection that you want this query to be, well, limited to. In this example, I limited the query to the ‘All Systems’ collection.
On the membership rules I chose to use incremental updates so that I had a more accurate collection. The best practice is to limit your use of incremental updates but it can be implemented on something like 200 collections.
See this link here for more details on best practices for collections: http://technet.microsoft.com/en-us/library/gg699372.aspx
Click the ‘Add Rule’ button and select ‘Query Rule’ from the drop-down menu.
Give the query rule a meaningful name and then click on the ‘Edit Query Statement’ button.
Select the ‘Criteria’ tab and click on the little goldy-yellowy-starry sun type button.
On the ‘Criterion Properties’ box, leave the criterion type as ‘Simple Value’ and click the ‘Select’ button.
On the ‘Select Attribute’ box, select ‘Client Status’ for the Attribute class and then select, ‘Client Activity’ for the Attribute.
To query Active computers: On the ‘Criterion Properties’ box, ensure that the ‘Operator’ is set to: ‘is equal to’ and the value is set to: 1
To query Inactive computers: On the ‘Criterion Properties’ box, ensure that the ‘Operator’ is set to: ‘is equal to’ and the value is set to: 1
In this example, I am creating a query for active computers, so I will use the value of 1 as per my screenshot below:
Click the OK buttons (three times) and you will be back at the ”Create Device Collection Wizard’ box with your newly created query proudly on display.
Click the Next button, then click Next again at the Summary screen and you should be presented with a successful outcome.
Click the close button and you’re done!