question

RonaldSeow avatar image
0 Votes"
RonaldSeow asked RonaldSeow commented

SCCM Collections and Memberships

Good morning!

Has anyone experience a collection contains another collection in its membership but that collection is not in the list of collections in within SCCM? The version of SCCM I have is 1702.

Example;
in Collection_A the members are Host_1, Host_2, Collection_B, Collection_C.
in Collections, Collection_B could not be located and also not listed when querying the table v_Collections or v_CollectionMemberClientBaselineStatus

Also, does anyone have a SQL query to query for members in a collection including nested collections that can share with me?

Appreciate any advise.

Thank you and best regards.
Ronald

mem-cm-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Jason-MSFT avatar image
1 Vote"
Jason-MSFT answered RonaldSeow commented

Plus 1 to @AllenLiu-MSFT's comments: your site is way out of support.

What's most likely happening here is that there was a design flaw where renamed collections did not get updated in include and exclude rule names; i.e., if you renamed a collection that was referenced in an include or exclude rule, the rule would still work, but the display name for that rule wouldn't be updated to reflect the new name.

The fix here is to upgrade to a supported version of ConfigMgr as this was addressed at some point in the last 4 years.

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Good morning! Jason,

Thanks for the reply. Your explanation is what I needed.

Thanks everyone.

Ronald

0 Votes 0 ·
AllenLiu-MSFT avatar image
0 Votes"
AllenLiu-MSFT answered

Hi, @RonaldSeow
Thank you for posting in Microsoft Q&A forum.
We can use below SQL query to find all memberships in a collection, replace the CollectionID to use it:

 SELECT COL.Name AS 'Collection Name'
 ,CASE (CR.RuleType)
 WHEN '3' THEN 'Include'
 WHEN '4' THEN 'Exclude'
 WHEN '2' THEN 'Query'
 WHEN '1' THEN 'Direct'
 END AS 'Rule Type'
 ,CR.ReferencedCollectionID AS 'Referenced Collection ID'
 ,CR.QueryName AS 'Referenced Collection or Device Name'
 FROM v_Collection COL
 JOIN Collection_Rules CR ON COL.CollID = CR.CollectionID
 where COL.CollectionID = 'XXXXXXXX'

And your issue is very strange, because if collection A is a member of collection B, the collection A will not be able to deleted.
By the way, you are using SCCM 1702, it is not supported for a long time, it's recommended to upgrade to SCCM 2010 or 2103.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.