I'm just wondering if there is a simple way to export a list of active Confluence spaces into a simple CSV. Ideally, it would be directly from the Space Directory where the space name, key, description, and category are shown.
Anything like this possible?
Hello @Andrew Zimmerman _Appfire_
There isn't any option in confluence to fetch the complete list of active confluence spaces into CSV format.
By the way, there is one option to fetch the list of the active spaces from the database below SQL query will help to identify those spaces. It will give you space_id, space name, etc.. you will need to modify the SQL query a bit as per your requirement.
In SQL Developer, right-click on the result/output section and select export and select .csv format.
I found it on the Atlassian documentation:
https://confluence.atlassian.com/confkb/how-to-get-a-list-of-all-the-active-personal-spaces-938860816.html
Thanks
Note: Upvote, Like or Accept Answer if it resolves your query.
Got it. Thanks, @Prashant Sultania.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Prashant Sultania in the linked article it is marked as 'only for Server version'. I need something for Cloud instance, as this is really hectic to go through the spaces and pick those that belonged to once active users. Also it would be useful to see how much MBs is each of these spaces taking up. You think that @Atlassian is going to do something about it?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.