How to list all the owner, users and groups of each spaces using automation ?

[Issac Franklin David]

I am looking to generate automatic report which lists all the spaces in our environment along with owner of the space, users and groups which are associated with it.

I am using Confluence cloud.

[Kshitiz Awasthi]

Hey @Issac Franklin David 

I agree with what @Bill Sheboy says, it'll be quite complex depending on the size of your site and the number of users & groups to list such info using automation.

You could still do the spaces and their space owners as this can be covered with a single (Get Spaces) REST APIs (as a webrequest action), which need to be executed along with a smart value branch to handle the cursor value. The same API will return the space owner's AAID. Then depending on your use case, you can run the second API (Get User by AAID) to fetch the user names for these owners. Please feel free to reach out to Atlassian Support if you need assistance with this part.

However, adding the allowed users and groups for space permissions will surely hit the limits and end up throttling your automation.

Best options would be either to explore some apps over at  Atlassian Marketplace or prepare a python script to run the Get Spaces as well as Get space permissions assignment APIs and collect the info and export the output as a CSV report or write it on a confluence page, depending on your use case.

Regards,

Kshitiz Awasthi

[Bill Sheboy]

Hi @Issac Franklin David -- Welcome to the Atlassian Community!

Short answer: I do not believe that is possible with an automation rule when there is a lot of content.  You may want to investigate the Atlassian Marketplace for apps to do this type of reporting.

Rule actions, branches, etc. all have limits on the number of pages / content which can be looked up.  And, the public REST API endpoint for searching with CQL has an even lower limit, requiring paging through the results.  Thus, when there are more than around 150 pages, it is unlikely a single report / message could be created for what you ask.

Kind regards,
Bill