How to export space and groups

Anne Finger October 10, 2024

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.

 

1 answer

0 votes
Humashankar VJ
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
October 10, 2024

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events