DB query to get list of Spaces

[Sonam Arya]

Is there a DB query to pull the list of Confluence spaces with the below details

Space name

Space key

Space creator

Category

Sub category(if any

[Brant Schroeder · Accepted solution]

@Sonam Arya Welcome to the Atlassian community

This should get you started.  You will have to make some adjustments to it https://confluence.atlassian.com/confkb/how-to-view-a-list-of-all-space-creators-and-administrators-for-all-spaces-346325879.html 

[Brant Schroeder]

@Sonam Arya can you accept this answer to help others?