Download all confluence pages updated in the last 2 years

[Houssein Barkallah]

Hello,
I have a Confluence Data Center, and I was looking into downloading all pages in public spaces that have been updated in the last 2 years. 

I can export complete spaces, but that will include all pages, even pages that are too old. 

Thank you

[Nick Nader · Accepted solution]

Hi @Houssein Barkallah

Since you are on Data Center, this is something that you will have to query the database behind Confluence for.

This doc is a good starting point for identifying the pages that have been updated in a date range: https://confluence.atlassian.com/confkb/how-to-export-a-list-of-all-recently-modified-content-within-a-space-996643476.html

Please note the queries in this doc are for PostgreSQL and MySQL DBs and would need to be modified to work with other DB types.

Hope this helps,

Nick from Isos