Introduction

System Center Configuration Manager (SCCM) is a powerful tool that allows IT administrators to manage and deploy software, updates, and configurations across a network of computers. One of the key features of SCCM is the ability to create collections, which are logical groups of computers that can be targeted for specific actions or deployments.

To create collections in SCCM, you can use query rules based on specific criteria. These query rules allow you to define the conditions that computers must meet in order to be included in a collection. In this article, we will explore how to create collections in SCCM using the SCCM query rule.

Examples:

To create collections in SCCM using the query rule, you can follow these steps:

1. Open the SCCM console and navigate to the "Assets and Compliance" workspace.
2. Expand the "Device Collections" node and right-click on "Collections".
3. Select "Create Device Collection" from the context menu.

In the "Create Device Collection Wizard", you will be prompted to provide a name and a description for the collection. Once you have entered the required information, click on "Next" to proceed to the "Membership Rules" page.

On the "Membership Rules" page, you can define the query rule for the collection. Here is an example query rule that selects computers based on the Active Directory site name and client status:

Query Rule SCCM:

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.ADSiteName = "PS1" AND client=1

In this query rule, we are selecting the resource ID, resource type, name, unique identifier, domain or workgroup, and client status for each computer. We are filtering the results based on the Active Directory site name ("PS1") and the client status (client=1).

Once you have defined the query rule, click on "Next" to proceed to the "Summary" page. Review the information and click on "Next" to create the collection.