How to find where a group is being nested in Crowd
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
If you're looking to clean up your Crowd groups, you may need to gather information about them first. This includes understanding whether a particular group is nested within other groups. Crowd does not offer a native feature to retrieve information about nested group memberships.
Environment
Crowd 6.0.0
Diagnosis
Log in to your Crowd instance as an admin.
Navigate toGroups>Search Groups.
Search for or select the particular group you want information on.
Click on theDirect Memberstab.
Check the list of groups in this group.
Only the information about what groups are nested in that subjected group will be displayed. There's no information about in what groups the subjected group may be nested.
Cause
There's no native feature to retrieve information about where a particular group may be nested.
Solution
You can run the following SQL query to obtain membership information for a specific group. This example looks for a group namedsubjected_test_groupin thecwd_membershiptable:
1
2
3
SELECT parent_name
FROM cwd_membership
WHERE child_name = 'subjected_test_group';Was this helpful?