How can I identify all space administrators by querying the database?

Question

I would like to identify all space administrators so that they can be contacted.  Ideally the result set would include, space key, space name, admin names and email address.  Any assistance is appreciated, thanks!

Kian Stack Mumo Systems · Answer

That's really odd,  I can access the link!

Schm · Answer

Thanks Kian, that links returns 404 not found.  I will search for the documentation you mentioned instead.

Thanks again

Kyle

Kian Stack Mumo Systems · Answer

@Schm, Atlassian has some documentation that I think might be helpful for you to take a look at.

It contains a query to pull all the space administrators from the system in there. I think the only portion which isn't contained if the email address of the administrator.

Thanks,

Kian