How do I obtain content that has not been modified in a certain period of time?
Platform Notice: Cloud and Data Center - This article applies equally to both cloud and data center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Purpose
To find content that has not been modified since a specified date.
Solution
Via the Archiving Plugin
The Archiving Plugin is a great tool for managing outdated content.
Via SQL
This can be achieved by running the following SQL query on your Confluence database.
1
select * from content as c, spaces as s where c.spaceid = s.spaceid and s.spacename='INSERT SPACE NAME HERE' and c.LASTMODDATE < 'INSERT DATE HERE';
Updated on April 8, 2025
Was this helpful?
Still need help?
The Atlassian Community is here for you.