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

Question

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.

Thanks,

Brett Creech
Educational Technologist, Purdue University

Brett Creech · Answer

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.

Theinvisibleman · Answer

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

RambanamP · Answer

check this blogs

http://come2niks.com/sql-query-to-find-confluence-space-admins/

some more useful sql query's

http://www.divingintothedetails.com/confluence/use-sql-to-quickly-get-information-out-of-confluence/