Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Hello,

 

I would like to export all my Confluence spaces and the date of the last modification for each. I was following this documentation in order to get that through SQL query (https://confluence.atlassian.com/doc/finding-unused-spaces-or-pages-107184852.html). However, I don't need the personal spaces. Is there a way to be assertive like this since I don't have the power to simply eliminate unnecessary information?

Any help would be appreciated.

 

 

2 answers

1 accepted

0 votes
Answer accepted

Well, for starters, you will need to export the spaces one by one - unless you are fine generating the whole Confluence backup of everything (and even that is not recommended, native SQL backup is simply superior).

When you get the link to export one space, you get the URL structure so that you can automate the process (however.. and I can't stress this enough, do this synchronously, one by one, don't try to export all spaces at once, you might as well crash the instance that way).

Secondly, all personal space keys start with tilda '~', so that's one way to identify them at first sight. And more importantly, it should be very easy to exclude personal spaces from the query. I don't exactly have a db in my hands right now, but I'm fairly sure that there is something like a "personal" boolean somewhere. Just run a few selects on the tables you're querying from that kba.

0 votes
Ismael Jimoh Community Leader Dec 18, 2021

Hi @Gustavo Delazari Borges 

Why do you want to use SQL to export spaces. You could export each space from the UI and to my knowledge this gives you an xml file which contains all the information you need.

Thanks.

Hi Ismael, 

I couldn't find anything from the UI.

My idea is to get just a report (CSV or Excel file), containing all spaces and their respective last modification date.

Sql query is fine for me since I can specify the columns that I need. I was having a problem only to eliminate personal spaces from the query.

Thank you for your answer.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

953 views 7 42
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you