How can I see all updates for past three months in confluence?

[Chris Mandra]

Hi guys - I'm trying to see what confluence content was modified over last three months. Is there a simple way to do that?

[Luiz Maia [Atlassian]]

Hi Chris,

You can also visualise that information from the database.

The below query will list all Confluence content and order by the last modified date:

SELECT * FROM CONTENT ORDER BY LASTMODDATE

If you want to list only Confluence pages on that query you can also use the following query:

SELECT * FROM CONTENT WHERE CONTENTTYPE LIKE 'PAGE' ORDER BY LASTMODDATE

Thanks!

Kind regards,

Luiz Maia
Atlassian Support

[Eduardo Mallmann]

Hello Chris,

You can use the filters below to retrieve all updated content within a range:

To search for content created or modified within a certain date range, using the created or modified keywords. The date stamps are in numeric 'yyyymmdd' format:

created:[20000101 TO 20131231]

modified:[20000101 TO 20131231]

Please, check this page to see every search syntax you can use in Confluence: https://confluence.atlassian.com/doc/confluence-search-syntax-158720.html

I hope it helps,

Eduardo