See if a group is used

[Björn Annerskog]

Hi, how can i see if a group is used in permissions if I am not able to use SQL ?

Or how do i start using SQL for confluence

[Andrii Maliuta]

Hello @Björn Annerskog ,

You can try to iterate over spaces and get each space permissions:

https://developer.atlassian.com/cloud/confluence/rest/v2/api-group-space-permissions/#api-spaces-id-permissions-get

https://<SITE>.atlassian.net/wiki/api/v2/spaces/<SPACE_ID>/permissions

 the result will contain all group and their IDs:

"results": [
{
  "id": "111111",
  "principal": {
    "type": "group",
    "id": "aaa-d111-451d-aaaaaaaaa"
   },
 "operation": {
   "key": "delete",
   "targetType": "attachment"
 }
},
{
  "id": "2222222",
  "principal": {
    "type": "group",
    "id": "asdasdasd-d845-45cc-asdasd-asdasd"
   },
  "operation": {
  "key": "delete",
  "targetType": "blogpost"
 }
}
]

Then by the group ID, you can check if the group  you need is present in a space:

https://<SITE>.atlassian.net/wiki/rest/api/group/confluence-users

[Kian Stack Mumo Systems]

@Björn Annerskog, 

It looks like finding the permissions isn't really possible without manual work - see this feature suggestion. You could try using rest api to query each space permissions and find it that way.