The SCCM 2503 device collection helps you to target specific applications, updates or task sequences in your setup. Creating this collection is easy and straightforward.
Following the Configuration Manager 2503 site upgrade, it is crucial for administrators to update client agents to the latest version. This ensures that new features are fully functional and accessible, as they require up-to-date client agents.
The ConfigMgr 2503 upgrade increments that client version to 5.00.9135.1001. This version can be verified from the hierarchy settings of the site. Once you have the client version number with you, creating a device collection is easy.
The Updates and Servicing node in the console shows the client version of every update. Some hotfixes patch the clients and change the version number, while others don’t. From the below screenshot, notice that newly released hotfix KB33177653 updates the client version to 5.00.9135.1006.
WQL Query for Clients not upgraded to ConfigMgr 2503
You can use the query below to find clients that have not been updated to the latest version of the Configuration Manager version 2503.
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.ClientVersion != '5.00.9135.1001'
WQL Query for SCCM 2503 clients
You can use the below WQL query to create a device collection for clients that are already upgraded to version 2503.
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.ClientVersion = '5.00.9135.1001'
Create SCCM 2503 Device Collection
- Launch the Configuration Manager console. Go to Assets and Compliance and select Device Collections. Right-click the “Device Collections” node and select the option “Create Device Collection”.
- Specify the device collection name, choose the limiting collection and click Next. On the Membership Rules window, click Add Rule and from the drop-down, select Query Rule.
- In the Query Rule Properties box, enter the query name and click Edit Query Statement. Select the Criteria tab. Click Show query language and enter the SCCM 2503 client WQL query.
Click OK twice. Complete the remaining steps and then close the Create Collection Wizard. That’s all, you need to wait now and let the query run in the background and perform its job.
After a few minutes, you’ll notice that collection is updated and gathers all the computers who clients are updated/not updated based on the WQL query you’ve used. To view the computers that are running the older version of SCCM agent, right-click the SCCM 2503 device collection and select Show members. The console now lists those devices.
What’s next?
Once you find out the devices that are not running the latest client version, ensure they are online and manually install the ConfigMgr client on the collection. If you have enabled the automatic client upgrade, the agents should be updated when the devices are online.