How To Create Collection Based On Device Name With Wildcard

Jason Barrett Jason Barrett | 4 Jan 2024 | Device Collection

In this article I will show you how to create a device collection based on device name with wild card.

Today I needed to deploy google chrome only to desktop machines, to achieve this I created a device collection with a query to only include computers with the computer name WK* because in my company all desktop machines are names WK0009293 (For Example)

Device-Collection-Based-On-Device-Name-with-Wildcard

How To Create Collection Based On Device Name With Wildcard

To Create Device Collection Based On Device Name with Wildcard follow the below steps

  1. Open the Configuration manager console
  2. Browse to \Assets and Compliance\Overview\Device Collections
  3. Browse to the folder you wish to create the device collection
  4. Right click and select create device collection
  5. Give the collection a name and select the limiting collection (Below I have selected All Windows 10 machines as I only want windows 10 machines in this collection)
    create-sccm-device-collection
  6. Click Next
  7. Select add rule then click query rule
    create-sccm-query-rule
  8. Give the query a name (Below I have given Machines Starting With WK)
  9. Click on edit Query Statement
    sccm-query-rule-properties
  10. Click on the criteria tab
  11. Click on the sun icon
    query-statement-properties
  12. Click Select under criterion properties
  13. In Attribute class select “system resource” then in attribute select “NetBIOS Name”
  14. Click on OK to close the Select attribute box
    select-attribute
  15. In the operator box select “is like” then in the value box enter your device name using the % character as a wildcard
    wild-card-device-name
  16. In the example above I want to select all the machines that are names WT%%%%%%% for example WT0009293 (If you need help with this step please post a comment below and I will help you out)
  17. Click OK to close the Criterion Properties window
  18. Click OK to close the query statement properties window
  19. Click OK to close the query rule properties window
  20. Click next
  21. Click next
  22. Click Close
  23. Now right click on the device collection you just created and select update membership
    update-device-collection-membership
  24. For my device collection you can see there are 2373 members
    device-collection-updated
  25. Always check the members by right clicking on the device collection and select show members. Make sure the devices in the device collection are the one you expect to see. Note that only 1000 devices are shown, if you want to view all machines you need to click on the yellow box
    sccm-device-collection-wildcard-view-members