How can I get a list of all space administrators in my Confluence installation?

We are looking for a way to get a list of space administrators for our Confluence installation. We have 150+ individual spaces and we need to extract a list of those users who have Space Admin rights. I've seen the macro that will pull space admins for individual spaces but that does not meet my needs.

Is there any way to pull a list of anyone who has space admin privileges from any space within an installation? We're on Confluence 4.2.8.


Brett Creech
Educational Technologist, Purdue University

3 answers

1 vote
Joe Wai Tye Atlassian Team Sep 04, 2013

Hi Brett,

You should be able to do so via creating a custom user macro. You can find the full details of how to do this via this Knowledge Base article - How Do I View A List of All Space Administrators for All Spaces

Joe, we tried this - however our installation has ~180 spaces and I'm estimating over 50,000 users; we use Confluence as our university-wide wiki here at Purdue University. We ran the macro and it caused a lot of stress on the system.

Is there any thought to possibly have a report created that a system administrator can run that will list all spaces and space administrators? I think that would be a helpful addition to any administrator tools.

Looks like you can do this with the Confluence REST APIs. The SpaceDirectoryEntity object has a getAdmins() method that should get you what you want.

Is there another option, such as using a SQL query to get this information?

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in New to Confluence

How to use Confluence Cloud for stakeholder management

Most of us don’t need much convincing that stakeholder management is important. It just makes sense that keeping everyone in-the-know on projects and assigning clearly defined roles is key to having ...

1,182 views 4 6
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you