See if a group is used

Question

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 · Answer

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://.atlassian.net/wiki/api/v2/spaces//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://.atlassian.net/wiki/rest/api/group/confluence-users

Kian Stack Mumo Systems · Answer

@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.