How can you get a report on when spaces were last updated?

[Ashley Feit]

Our Confluence spaces have been ignored and I'm trying to get them updated. I know on a space, below the name, there is a line that indicates who and when the space was last updated. How can I pull a report for all our spaces on this information?

[AAMIR ANSARI]

Hi @Ashley Feit 

The easiest way to determine the last modified date for spaces is to query it from the database itself. For example:

SELECT spacename, spacekey, lastmoddate FROM spaces;

In case you are looking for more granular reports, you can check the below documentation that contains the list of different queries for different reporting purposes.

• https://confluence.atlassian.com/confkb/how-to-export-a-list-of-all-recently-modified-content-within-a-space-996643476.html

There might be better ways of obtaining these kinds of information as well through third-party add-on, for example Reporting for Confluence.

Thanks,
Aamir