How do I obtain content that has not been modified in a certain period of time?

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Data Center and Cloud By Request - This article was written for the Atlassian data center platform but may also be useful for Atlassian Cloud customers. If completing instructions in this article would help you, please contact Atlassian Support and mention it.

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.

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';
Last modified on Jan 23, 2025

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.