Report of all space administrators

[Daniel Vlad]

Hello,

is there a way to output the administrators of all spaces for an entire confluence instance, in a report?
The reason is, they need to be informed when the system has errors/ problems.

Regard

Daniel

[Sayed Bares _ServiceRocket_]

@Daniel Vlad I believe User List macro addresses your question. Just mention the groups which has administrator permission and you are good to go. It will even show you who is online and who is not.

[Daniel Vlad]

@Sayed Bares _ServiceRocket_ Hi Sayed, 

thanks for your answer.
I tried this macro before, but I can't query the space administrators through it.
This macro helps with the targeted query of Confluence groups from the general user directory.

Maybe the attached screenshot will help to better understand my issue.

[Sayed Bares _ServiceRocket_]

@Daniel Vlad then your best bet is to create your own user macro. https://community.atlassian.com/t5/Confluence-questions/List-all-space-administrators/qaq-p/259028 could be a good start.

[Alan Stephenson]

I don’t have this query at the moment but I found a sql command which you can run against your database. I’ll look for it and post tomorrow. 

Depending on how many spaces you have, it pulls all spaces and lists each space admin. The data may appear to repeat but at least this will let you get the data without looking at each space separately.

it also does personal spaces.