System Center Configuration Manager (SCCM) is a powerful tool used by IT administrators to manage devices and software within an organisation. One of the key functionalities of SCCM is the ability to create collections, which are groups of devices or users that you can manage collectively. Creating collections based on queries allows for dynamic and automated management of resources, ensuring that devices meet specific criteria and are kept up-to-date with policies and software deployments.

In this article, we will explore how to create SCCM collections using device queries. This is particularly important for IT professionals who need to manage large numbers of devices efficiently. We will provide practical examples and step-by-step instructions to help you implement this in your environment.

Exemplos:

1. Creating a Device Collection Based on an Operating System Version

   To create a collection of devices running a specific version of Windows, follow these steps:

   • Open the SCCM console.

   • Navigate to Assets and Compliance > Device Collections.

   • Right-click Device Collections and select Create Device Collection.

   • Name your collection, e.g., "Windows 10 Devices".

   • Choose a limiting collection, such as "All Systems".

   • In the Membership Rules section, click Add Rule > Query Rule.

   • Name your query rule, e.g., "Windows 10 Query".

   • Click Edit Query Statement > Show Query Language and enter the following 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
     inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId
     where SMS_G_System_OPERATING_SYSTEM.Caption like "Microsoft Windows 10%"

   • Click OK to close all dialogs and save the collection.

2. Creating a Device Collection Based on Software Installation

   To create a collection of devices with a specific software installed, follow these steps:

   • Open the SCCM console.

   • Navigate to Assets and Compliance > Device Collections.

   • Right-click Device Collections and select Create Device Collection.

   • Name your collection, e.g., "Devices with Microsoft Office".

   • Choose a limiting collection, such as "All Systems".

   • In the Membership Rules section, click Add Rule > Query Rule.

   • Name your query rule, e.g., "Microsoft Office Query".

   • Click Edit Query Statement > Show Query Language and enter the following 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
     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 "Microsoft Office%"

   • Click OK to close all dialogs and save the collection.