Introduction System Center Configuration Manager (SCCM) is a powerful tool used by Microsoft Systems Engineers 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 groupings of devices based on certain criteria. Query rules in SCCM allow you to define the criteria for creating collections dynamically. In this article, we will explore how to create collections in SCCM using query rules and provide examples of queries that can be used.

Examples:

Example 1: Creating a Collection for Windows 10 Workstations To create a collection for Windows 10 workstations, you can use the following query rule in 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.OperatingSystemNameandVersion like "Microsoft Windows NT Workstation 10.0%"

This query rule selects all systems where the operating system name and version match "Microsoft Windows NT Workstation 10.0%". This will include all Windows 10 workstations in the collection.

Example 2: Creating a Collection for Computers with a Specific Software Installed To create a collection for computers with a specific software installed, you can use the following query rule in 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
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 Reader%"

This query rule selects all systems where the software "Adobe Acrobat Reader" is installed. You can replace "%Adobe Acrobat Reader%" with the name of any software you want to target.

Example 3: Creating a Collection for Computers with a Specific Hardware Configuration To create a collection for computers with a specific hardware configuration, you can use the following query rule in 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
inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
where SMS_G_System_COMPUTER_SYSTEM.TotalPhysicalMemory >= 8192

This query rule selects all systems where the total physical memory is greater than or equal to 8192 MB. You can modify the value to target systems with a different amount of memory.