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

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 Feb 26, 2016

Was this helpful?

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