How to export space and groups

[Anne Finger]

Hello,

We want to make a export from the space and groups, this is to see how many groups are connected to the spaces.

When we have a overvieuw of this, we can see if there are multiple groups with the same permissions and users in them. Because we have a hunge that we are using alot of multiple groups with the same results.

[Humashankar VJ]

Hi @Anne Finger 

To export information about spaces and groups in Confluence and analyze their connections, you can follow these steps:

Exporting Space and Group Information

1. Use the Confluence REST API to extract the necessary data

 You'll need to make separate API calls for spaces and groups.

1. For spaces, use the following API endpoint:

REST API endpoint-1

/rest/api/space

1. For groups, use:

REST API endpoint-2

/rest/api/group

1. To get group permissions for each space, you'll need to make additional API calls for each space using:

REST API endpoint-3

/rest/api/space/{spaceKey}/permission

With your exported data in hand, you can now uncover valuable insights by analyzing:

The analysis will concentrate on three primary objectives:

Identifying the groups associated with each space,

Detecting spaces that share identical or overlapping group permissions,

And exposing users who hold multiple group memberships with comparable permissions.

To facilitate analysis, make use of -

• Spreadsheet Software (Excel, Google Sheets): Import CSV data for basic analysis.
• Data Visualization Tools (Tableau, Power BI): Create interactive visualizations of group-space connections.
• Custom Scripts (Python, R) Perform advanced analysis and data manipulation.

For more help refer the articles listed below:

Export Confluence spaces and pages (kolekti.com)

https://youtu.be/YjTqcbflFJk

Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards