Collections in SCCM are great! The Microsoft definition of a collection is as follows:

Collections are groupings of users or devices. [You] Use collections for tasks like managing applications, deploying compliance settings, or installing software updates. You can also use collections to manage groups of client settings or use them with role-based administration to specify the resources that an administrative user can access. Configuration Manager contains several built-in collections.1

But in many situations, dynamic collections are better. Dynamic collections will update or refresh the members based on a set of rules or query that you set. This can be helpful because devices can be added to the collection as conditions change. Dynamic collections are the same thing as an explicit member collection so they can can be used to:

  • Deploy software
  • Complete software updates
  • Establish security baselines

…or simply for administrative purposes.

This short article will introduce you to building a dynamic collection based off of your naming standards (ComputerName). This can be helpful if your devices are named after a physical location or a site prefix. As devices get renamed, rebuilt, or moved, the collection will remain accurate.

While this is an introduction to dynamic collections, the possibilities of what to query (including completely custom attributes) are numerous and are out of scope for this particular blog article.

Learn How Unified Endpoint Management Improves Security And Reduces Costs

In our century of cybercrime, learn more about how you can increase your security, efficiency, and reduce your costs through our UEM video series.

Model says no to spam. Privacy Policy

How To Build A Dynamic Collection


  • Server names are as follows: TMSModel01, MINModel01, RMDModel01
  • Computers that connect to these servers are named with the same prefixes, e.g., TMS, MIN, RMD (TMS1itach, MINwe12, RMDhop21)


  • We want to pull every machine that connects to the servers listed above to a collection
  • We want the flexibility to edit the Prefixes to where you can change them, add them, or remove them

First, in ‘Device Collections’, right click ‘Device Collections’ and select ‘Create Device Collections’

Once the Create Device Collection Wizard appears, name the collection appropriately. In our case we used a very detailed naming standard such as ‘All Windows 10 Connecting to Server MINModel01, TMSModel01, RMDModel01′.

Next, provide a limiting collection. For example, ‘All Windows 10 Systems’ (which will need to be created) or you can use ‘All Systems’. In our case since the devices we are looking for are all Windows 10, we selected ‘All Windows 10 Systems’.

Keep in mind there are many considerations for choosing what the limiting collection should be, but I’ll cover those in a different blog!

Next, to access the membership rules, click ‘Add Rule’. You will be given options. Select ‘Query Rule’.

Once you’re inside the query rule option:

1. Name the Query Rule (ex. Win10 Prefixes)

2. Click ‘Edit Query Statement’

3. Click ‘Show Query Design’ and enter this 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 where SMS_R_System.Name like “TMS%” or SMS_R_System.Name like “MIN%” or SMS_R_System.Name like “RMD%”

OR you can hit the new query rule, e.g. the yellow star.

Make these selections and add this information:

  • Criterion Type: Simple Value
  • Where: Hit Select…
    • Attribute class: System Resource
    • Attribute: Name
  • Operator: Select “Is Like”
  • Value: MIN%

Repeat this process for the other prefixes you are looking for.

And here are our finished collection results!

Congratulations! You’ve set up a dynamic collection!

About the Author: Model Technology Solutions

Our reputation is one of doing great work, sticking to what we do best and being easy to work with. We are a small but mighty band of infrastructure experts dedicated to helping our clients get their infrastructures on “cruise control”. Implementing automation, configuration, best practices and lessons learned helps us make our clients look good and sleep better.

Three Minutes For A More Secure & Efficient Infrastructure

Short and to the point, Steve’s Email Blasts give you endpoint management tips, tricks, and news in three minutes or less email read-time, guaranteed.

Model says no to spam. Privacy Policy

Model Technology Solutions

Model Technology Solutions is a small but mighty band of infrastructure experts. We’ve helped companies in diverse industries to modernize and automate their infrastructures through effectively managing their Microsoft endpoint suite.

With us on your team, you’ll watch your security and compliance go up and your IT team’s costs (and headaches) go down. You’ll relax in knowing that your endpoints will be secure and online when your users need them most. And you’ll finally get back to your most-important tasks.

Model Technology Solutions
12125 Woodcrest Executive Drive, Ste. 204 Creve Coeur, MO 63141

Phone: (314) 254-4138
General Inquiries:
Sales and Quotes: