The Best Way to Find Collection ID in SCCM | ConfigMgr

Let’s learn how to find Collection ID in SCCM. We have 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 collections IDs are important. The main reason to get the collection ID details is to run Configuration Manager default reports. So, the fresh SCCM admin should know where to get the collection IDs.

Related posts 1. SCCM Collections – How To Build Static Collection SCCM 2. How to create dynamic collections? Create Collection Folders 3. Create AD Group Based SCCM Collection.

Default View

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

ConfigMgr How to Find Collection ID in SCCM
ConfigMgr How to Find Collection ID in SCCM

Add Collection ID Column

Patch My PC
Advt

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 Device Collection or User Collection nodes.
  • Select the Collection ID column from the list.
ConfigMgr How to Find Collection ID in SCCM
ConfigMgr How to Find Collection ID in SCCM
  • Now check the corresponding collection ID value against each collection.
    • For example – The collection ID for the HTMD Collection is MEM00014
      • All Systems = SMS0001
ConfigMgr How to Find Collection ID in SCCM
ConfigMgr How to Find Collection ID in SCCM

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 SCCM primary server or CAS. The Collections ID of these types of collections starts with SMS.

ConfigMgr How to Find Collection ID in SCCM
ConfigMgr How to Find Collection ID in SCCM

Best Method to Find Collection ID

1E Nomad
Advt

With the 2103 version of Configuration Manager, you can go into the following location in the SCCM console and find out the collection ID details.

  • 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.
Collection Evaluation Summary - Best Way to Find Collection ID in SCCM
Best Way to Find Collection ID in SCCM

Basic Collection FAQs

How many types of Collections are there?

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

Collection Queries are based on SQL or WQL?

WQL

Where you can find the Collection ID in SCCM?

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

Resources

Sharing is caring!

Leave a Comment

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