Fix SCCM Limiting Collection Issue | Stop Using Collections Limited to All Systems or All Users

Let’s understand why you should stop using SCCM collections limited to All Systems or All Users and Fix SCCM Limiting Collection Issue. All Users and All Systems collections are the default collections available in the SCCM hierarchy.

I have explained the collections in various blog posts. How to create dynamic collections, how to create collections based on the Active Directory group? How to easily find out WQL queries from log files etc.

In this post, I will share one of the best practices that you must follow when you create a custom device or user collection. Even I didn’t take care of it in the lab environment for a long time. Because I always followed the easiest method.

Patch My PC

I don’t think the easiest method will always be the best method to follow. Similarly, in this post, you will see why you should not use All Systems or All Users as a limiting collection while creating custom SCCM collections.

Management insights are one of my favorite features of SCCM. This helps the SCCM admins to keep the infrastructure healthy.

What is Limiting Collections in SCCM?

The limiting collection establishes the resources you can add to the custom collection using membership rules. In other words, the collection you’re creating will contain only members from the limiting collection.

The custom SCCM collection that you create is limited to the resources of the collection that it’s limiting. The custom collection members will be the subset of the limiting collection.

Fix SCCM Limiting Collection Issue | Stop Using Collections Limited to All Systems or All Users
Fix SCCM Limiting Collection Issue | Stop Using Collections Limited to All Systems or All Users

You can’t change the limiting collection of the default collections such as All Desktops and Server Clients, All Provisioning Devices, All Unknown Computers, etc. The browse button to change limiting collection is disabled for the default collections.

The collection ID for default collection always starts with SMS—–, as shown in the below screenshot. You can’t change the limiting collection for these types of collections.

Fix SCCM Limiting Collection Issue | Stop Using Collections Limited to All Systems or All Users
Fix SCCM Limiting Collection Issue | Stop Using Collections Limited to All Systems or All Users

Default Collections Vs. Custom Collections in SCCM

Let’s discuss the difference between Default Collections Vs. Custom Collections in SCCM. The default collections are the collection that is built-in and available ready to use as out of the box.

Custom collections are created by SCCM admins using the admin console or by any automation mechanism. You can identify the custom Collections with Collection IDs.

  • Custom Collection IDs start with site code – MEM00011 (where MEM is the sitecode)
  • Built-in Collection IDs start with SMS – SMS00001
Default Collections Vs. Custom Collections in SCCM
Default Collections Vs. Custom Collections in SCCM

Management Insights – Collections Limited to All Systems or All Users

Let’s check the Management Insights rule to check the list of collections limited to All Systems or All Users. A rule checks whether admins created custom collections and All Systems or All Users collections configured as their limiting collection.

Navigate to \Administration\Overview\Management Insights\All Insights\Configuration Manager Assessment. Now run the rule Collections limited to All Systems or All users.

Management Insights - Collections Limited to All Systems or All Users
Management Insights – Collections Limited to All Systems or All Users

As you see below, many custom collections use the All Users collections as a limiting collection. This is not good practice for your SCCM infrastructure.

Management Insights - Collections Limited to All Systems or All Users
Management Insights – Collections Limited to All Systems or All Users

Check Limiting Collections from SCCM Console

Let’s understand how to check limiting collections from SCCM Console. You can check this from the Device Collections or User Collections node.

There is a column called Limiting Collection in the console, as shown in the below screenshot to check the Limiting Collection. You can check the limiting collection column to find the limiting collection details.

Check Limiting Collections from SCCM Console
Check Limiting Collections from SCCM Console – Fix SCCM Limiting Collection Issue

Why Stop Using SCCM Collections Limited to All Systems or All Users?

Let’s understand why to stop using SCCM collections limited to All Systems or All Users. Jose Rodrigues (Microsoft PFE) provided the details on this topic, as you can see in the below screenshot.

Let’s understand All Systems and All Users collections first. These collections are all in one collection for all the users and the device records for your SCCM environment. Both these collections are updated regularly based on the data coming from Active Directory Discovery.

WQL Query for All Systems collection is given below. This All Systems collection doesn’t have any limiting collection, but the data comes from different discovery methods. The most prominent one is Active Directory discovery.

select Name, SMSAssignedSites, IPAddresses, IPSubnets, OperatingSystemNameandVersion, ResourceDomainORWorkgroup, LastLogonUserDomain, LastLogonUserName, SMSUniqueIdentifier, ResourceId, ResourceType, NetbiosName, ClientType from sms_r_system

Why Stop Using SCCM Collections Limited to All Systems or All Users?
Why Stop Using SCCM Collections Limited to All Systems or All Users?

The WQL query for All Users Collection is given below. This All Systems collection doesn’t have any limiting collection, but the data comes from Active Directory discovery.

select Name, UserName, WindowsNTDomain, NetworkOperatingSystem, AgentName, AgentSite, AgentTime, ResourceId, ResourceType, UniqueUserName from sms_r_user

Why Stop Using SCCM Collections Limited to All Systems or All Users?
Why Stop Using SCCM Collections Limited to All Systems or All Users? Fix SCCM Limiting Collection Issue

Mismatch and Inaccurate Results for SCCM Deployments & Report

Let’s discuss the data mismatch that can cause inaccurate results for SCCM deployments & reports. As per Microsoft, you should not use All Systems or All Users collection as limiting collections for all the customs collections.

Use All Systems or All Users collection as limiting collections for all the customs collections. You might get into data mismatch and inaccurate results for deployments and reports. This is mainly because of the data coming into these two collections via Active Directory discovery.

NOTE! – All is good if you have well maintained and clean Active Directory. In most scenarios, I have not seen a well-maintained and clean AD.

SCCM Performance Issues because of Limiting Collections

The “Limiting Collections” configurations could cause SCCM performance issues for the SCCM environment. I think that is one of the reasons Microsoft created a Management Insights rule specifically for limiting collections.

The performance impact to the SCCM infra is because of the evaluation time taken to update all the limiting collection. Whenever there is an evaluation triggered for custom collection, the update is triggered for the limiting collection.

So if you have many custom collections that are limited to the All Systems and All Users collection, these two collections will be updated frequently, and this could cause performance issues for the SCCM (a.k.a ConfigMgr) hierarchy.

Collection Evaluation details – ConfigMgr Collection Full Incremental Evaluation Status

SCCM Performance Issues because of Limiting Collections
SCCM Performance Issues because of Limiting Collections – Fix SCCM Limiting Collection Issue

Recommendations for Limiting Collection

Let’s check the recommendations when you use All Systems or All Users Collection as limiting Collections.

  • Make sure that there is regular cleanup is performed on Active Directory.
  • Make sure the proper SCCM AD discovery configurations are in place. Try to be specific with OUs for SCCM system and User AD discovery.
  • Review all the collection that use the All Systems or All Users Collections to select more specific collection whereever possible as Limiting Collection.
Recommendations for Limiting Collection
Recommendations for Limiting Collection – Fix SCCM Limiting Collection Issue

Fix SCCM Limiting Collection Issue

You can fix SCCM limiting Collection issue highlighted in Management Insights using the following method. Otherwise, you can use the PowerShell commandlets to fix the issue.

It would help if you stopped using SCCM collections limited to All Systems or All Users to fix the SCCM limiting collections issues such as performance and data mismatch that can cause inaccurate results in SCCM deployment reports.

Navigate through – \Assets and Compliance\Overview\Device Collections and select collections limited to All Systems collection.

Fix SCCM Limiting Collection Issue
Fix SCCM Limiting Collection Issue

You will need to click on the Browse button to change the Limiting Collection from the General tab of Collection properties.

Select the appropriate collection from the Select Collection window as a new limiting collection and click on the OK, and OK complete the process.

NOTE!Repeat this process for all the Collections for which All Systems or All Users configured as limiting collection.

Fix SCCM Limiting Collection Issue
Fix SCCM Limiting Collection Issue

Author

Anoop is Microsoft MVP! He is a Device Management Admin with more than 20 years of experience (calculation done in 2021) in IT. He is Blogger, Speaker, and Local User Group HTMD Community leader. His main focus is on Device Management technologies like SCCM 2012, Current Branch, and Intune. He writes about ConfigMgr, Windows 11, Windows 10, Azure AD, Microsoft Intune, Windows 365, AVD, etc.

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.