Identify groups being used by Bitbucket

[William Frank Merlock]

We have a rather large set of groups defined in our system, and we are looking to determine which groups are actively being used, and which we might be able to remove.  I'm not sure how to tell which groups are being used in Bitbucket.  I found this post on Jira groups (https://confluence.atlassian.com/jirakb/how-to-identify-group-usage-in-jira-441221524.html) very useful; is there similar such documentation for Bitbucket?  (... and for bonus points, Bamboo?)

[William Frank Merlock]

This isn't authoritative, but if someone is hunting this down, here are some places to look:

• table sta_repo_permission, column group_name
• table sta_project_permission, column_name group_name
• table sta_global_permission, column group_name
• table AO_6978BB_PERMITTED_ENTITY, column GROUP_ID
• table cwd_app_dir_group_mapping, column group_name
• table cwd_app_dir_default_groups, column group_name
• table cwd_granted_perm, column group_name

For Bamboo:

• table acl_entry, column sid
  • where type = 'GROUP_PRINCIPAL' AND mask != 0
• table cwd_app_dir_group_mapping, column group_name
• table cwd_app_dir_default_groups, column group_name
• table cwd_granted_perm, column group_name