Create Device Collection for Windows Server 2025 in SCCM

Group all the devices running Windows Server 2025 into a device collection in Configuration Manager

Prajwal Desai
Posted by Prajwal Desai
Create Device Collection for Windows Server 2025 in SCCM

In this guide, I will cover the steps to create a Windows Server 2025 device collection in SCCM. A WQL query can be used to group all devices running Windows Server 2025 into a dedicated device collection.

The latest server operating system from Microsoft is Windows Server 2025. It is also referred to as the Windows Server version 24H2 update. Server 2025 focuses on enhancing security, improving performance, and introducing innovative features. I recommend reading this useful guide on how to download and Windows server 2025.

Before publishing this guide, I performed a client push on Windows Server 2025 and the client agent installation was successful. I used SCCM 2403 to push the client agent on to Server 2025. You may also use Technical Preview 2405 or a higher version to deploy the client agent.

Microsoft is yet to confirm the exact version of ConfigMgr that fully supports its client on Server 2025. I will update this guide once that information is available.

Also See: How To Audit SCCM Device Collection Changes

Build number of Windows Server 2025

The WQL query that we will use to create the collection for Server 2025 primarily uses the OS build number. You may also use the OS caption for grouping Server 2025 devices, but it may not be as accurate as using the build number.

One can manually find the build number on Windows Server 2025 by going to Start > Settings > About > Windows Specifications.

Operating System and Full OS build numbers are easily retrieved from the device discovery data in the SCCM console. Right-click a Windows Server 2025 device in the SCCM console and select Properties. In the General tab, scroll down and locate the Operating System Build and Full Operating System Build.

From the below screenshot, here are the build details for Server 2025:

  • Windows Server 2025 Operating system build number: 10.0.26100
  • Windows Server 2025 Full Operating system build number: 10.0.26100.560
Find Build number of Windows Server 2025 using SCCM
Find Build number of Windows Server 2025 using SCCM

Useful Guide: Create SCCM Collection for Co-Managed Devices

Create Windows Server 2025 device collection in SCCM

Follow the below steps to create a Windows Server 2025 device collection in SCCM:

1. Launch the Configuration Manager console and navigate to the Assets and Compliance workspace. Right-click the Device Collections node and select Create Device Collection.

Create Windows Server 2025 device collection in SCCM
Create Windows Server 2025 device collection in SCCM

2. Enter the device collection name as Windows Server 2025 Collection. Choose the limiting collection and click Next.

Create Windows Server 2025 device collection in SCCM
Create Windows Server 2025 device collection in SCCM

3. On the Membership Rules window, click Add Rule and from the drop-down, select Query Rule.

Create Windows Server 2025 device collection in SCCM
Create Windows Server 2025 device collection in SCCM

4. In the Query Rule Properties box, enter the query name and click Edit Query Statement. In the Query statement properties window, select the Criteria tab. Click Show query language and enter the below WQL query to create a Windows Server 2025 device collection.

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.Version = "26100"
WQL Query for Windows Server 2025 Collection
WQL Query for Windows Server 2025 Collection

5. Click OK three times and continue with the Create Device Collection Wizard. Review the changes on the Summary page. Complete the remaining steps and close the wizard.

Create Windows Server 2025 device collection in SCCM
Create Windows Server 2025 device collection in SCCM

After a few minutes, in the SCCM console, check the member count of the Windows Server 2025 device collection. The collection should group all the Windows 2025 servers in your hierarchy.

If the Server 2025 device collection is not updating, review the colleval.log that records details about when collections are created, changed, and deleted by the Collection Evaluator.

Read Next

Share This Article
Prajwal Desai
Posted by Prajwal Desai
Follow:
Prajwal Desai is a Microsoft MVP in Intune and SCCM. He writes articles on SCCM, Intune, Windows 365, Windows Server, Windows 11, WordPress and other topics, with the goal of providing people with useful information.
Leave a comment