Introduction to SCCM Query Collection and its Importance

System Center Configuration Manager (SCCM) is a powerful tool used by Microsoft Systems Engineers to manage and deploy software, updates, and configurations across a large number of Windows devices. One of the key features of SCCM is the ability to create and run query collections, which allow you to gather information about specific attributes of your managed devices.

In this article, we will focus on creating and running an SCCM query collection to retrieve information about Windows devices with a specific operating system build number. This can be particularly useful in scenarios where you need to identify devices that are running a specific version of Windows, such as when planning for software upgrades or troubleshooting compatibility issues.

Examples:

To create the SCCM query collection, follow these steps:

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

In the "Create Query Collection Wizard," provide a meaningful name for your collection and click "Next." In the next step, you will define the query rule that filters devices based on the operating system build number.

4. Click on the "Add Rule" button and select "Query Rule" from the drop-down menu.
5. In the query rule properties, provide a name for the rule and click on the "Edit Query Statement" button.

In the "Query Statement Properties" window, you can define the query statement using the SCCM query language. Here's an example of the query statement to filter devices with a build number of "14393":

select * 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.BuildNumber = "14393"

6. Click "OK" to save the query statement and then click "Next" in the query rule properties.
7. Review the summary of your query collection and click "Next" to complete the wizard.
8. Once the query collection is created, you can deploy it to specific devices or use it for reporting purposes within SCCM.

By following these steps, you can easily create and run an SCCM query collection to retrieve information about Windows devices with a specific operating system build number. This can greatly assist in managing and maintaining your Windows infrastructure, ensuring compatibility and efficient software deployments.