Skip to content
The Best Way to Find Collection ID in SCCM | ConfigMgr

The Best Way to Find Collection ID in SCCM | ConfigMgr

Written By Anoop C Nair
Last Updated August 23, 2024
Posted In SCCM
SHARE

Let’s learn how to find Collection ID in SCCM. We received an interesting comment on one of the posts: SCCM Patch Status SQL Query Based on Particular Collection | ConfigMgr. I understand the trouble here because the default console view doesn’t have collection IDs.

Now, let’s understand why the collection IDs are important. The main reason for getting the collection ID details is to run Configuration Manager default reports. So, the fresh SCCM admin should know where to get the collection IDs.

SCCM Collections are critical in the SCCM environment. We should be careful when creating or modifying collections, as they can cause performance issues.

For more details about the collections please refer the following posts: SCCM Collections – How To Build Static Collection SCCM 2. How to create dynamic collections? Create Collection Folders 3. Create AD Group-Based SCCM Collection.

Patch My PC

How many types of Collections are there?

Mainly, 2 types of collections are available. User collections and Device Collections.

Are collection queries based on SQL or WQL?

WQL

Where can you find the Collection ID in SCCM?

From the SCCM 2103 version onwards \Monitoring\Overview\Collection Evaluation\Full Evaluation Status

Default View

The default ConfigMgr console view from the Assets and Compliance workspace doesn’t show collection ID details. Let’s get the collection ID details from the SCCM console.

The Best Way to Find Collection ID in SCCM | ConfigMgr - Fig.1
The Best Way to Find Collection ID in SCCM | ConfigMgr – Fig.1

Add Collection ID Column

The following steps will give you the details of the collection ID that you require for filtering or running an SCCM report.

  • You can add a new column by right-clicking on any of the columns from the Device Collection or User Collection nodes.
  • Select the Collection ID column from the list.
The Best Way to Find Collection ID in SCCM | ConfigMgr - Fig.2
The Best Way to Find Collection ID in SCCM | ConfigMgr – Fig.2

Now check the corresponding collection ID value against each collection.

  • For example – The collection ID for the HTMD Collection is MEM00014
    • All Systems = SMS0001
The Best Way to Find Collection ID in SCCM | ConfigMgr - Fig.3
The Best Way to Find Collection ID in SCCM | ConfigMgr – Fig.3

Default Collection Vs Custom Collection?

Let’s understand the difference between custom collections and default collections.

Custom Collections = These are the ones created by SCCM admins. The collection IDs of a custom collection start with your site code. In my example, all my custom collection IDs start with MEM.

Default Collections = These are built-in collections automatically created when you install the SCCM primary server or CAS. The Collections ID of these types of collections starts with SMS.

The Best Way to Find Collection ID in SCCM | ConfigMgr - Fig.4
The Best Way to Find Collection ID in SCCM | ConfigMgr – Fig.4

Best Method to Find Collection ID

With the 2103 version of Configuration Manager, you can access the collection ID details by going to the following location in the SCCM console.

  • Navigate to \Monitoring\Overview\Collection Evaluation node
  • Click on Full Evaluation Status to get all the details about collections available in your Configuration Manager infra.
  • You can check the collection ID for each collection from this place.
The Best Way to Find Collection ID in SCCM | ConfigMgr - Fig.5
The Best Way to Find Collection ID in SCCM | ConfigMgr – Fig.5

Resources

We are on WhatsApp now. To get the latest step-by-step guides, news, and updates, Join our Channel. Click here – HTMD WhatsApp.

Author

Anoop C Nair has been Microsoft MVP from 2015 onwards for 10 consecutive years! He is a Workplace Solution Architect with more than 22+ years of experience in Workplace technologies. He is also a Blogger, Speaker, and leader of the Local User Group Community. His main focus is on Device Management technologies like SCCM and Intune. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security, Career, etc.

Written by

Anoop C Nair is Workplace Technology solution architect with 25+ years of experience in global enterprise organizations such as JP Morgan, Capgemini, etc. Microsoft Certified Trainer. Microsoft MVP from 2015 onwards for consecutive 11+ years! He also conducts Intune and modern workplace tech training for enterprise organizations. He is Blogger, Speaker, and Founder of HTMD Community and HTMD Conference. His main focus is on Device Management technologies like Intune, Windows, Cloud PC. He writes about technologies like Intune, SCCM, Windows, Cloud PC, Windows, Entra, Microsoft Security.

Discussion

Join the discussion

Your email address will not be published. Required fields are marked *

Related guides

Intune

Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws

Key Takeaways Windows 11 KB5101650 KB5099414 July 2026 Patch and 3 Zero Day Vulnerabilities and 570 Flaws! In the July 2026 Patch, Microsoft introduced new features designed to improve the overall Windows experience. The update adds enhancements to Windows Update for more flexible update management and introduces Point-in-Time Restore, providing an additional recovery option for […]

AC Anoop C Nair 9 min read
Intune

2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws

Key Takeaways 2026 June KB5094126 KB5093998 Windows 11 Patch | 3 Zero Day Vulnerabilities and 200 Flaws! The June 2026 Windows 11 Patch Tuesday update brings several improvements to File Explorer. It adds support for additional archive formats, including UU, CPIO, XAR, and NuGet Packages (NUPKG). The update also preserves View and Sort preferences in […]

AC Anoop C Nair 10 min read
Intune

2026 May KB5089549 KB5087420 Windows 11 Patch | 0 Zero Day Vulnerabilities and 120 Flaws

Key Takeaways The Windows 11 May 2026 Patch KB5089549 KB5087420 Update brings important security fixes, performance improvements, and reliability enhancements across the operating system. The update introduces new features such as Xbox Mode for gaming, File Explorer improvements, enhanced input and sharing experiences, better taskbar and Windows Hello reliability, and additional enterprise management capabilities for […]

AC Anoop C Nair 8 min read
SCCM

ConfigMgr 2603 Introduces New Early Update Enrollment Process

Key Takeaways In this post we are discussing the ConfigMgr 2603 Introduces New Early Update Enrollment Process. Microsoft has officially released Configuration Manager version 2603 to the Early Update Ring, giving organizations an opportunity to test upcoming improvements before the global production rollout. The release is targeted at enterprises running ConfigMgr version 2409 or later […]

AC Anoop C Nair 3 min read