Checking last time spaces are modified for a Confluence Instance

[Bakul Warikoo]

I am trying to extract data for all the spaces present under our Confluence Instance (Server). We need the info regarding the last date of modification of space along with space name. We are in process of archival of spaces which are not in use for long hence, this request. 

I have run the below query however, this query does not show proper data (incorrect data is present), and along with that, it is listing down couple of spaces which have been deleted long back. Any inputs on how to do this?

SELECT spaces.spacename, MAX(content.lastmoddate) FROM CONTENT as content, SPACES as spaces WHERE content.spaceid = spaces.spaceid GROUP BY spaces.spacename;

[O]

Try this:

https://marketplace.atlassian.com/apps/186/reporting-for-confluence?hosting=server&tab=overview

Based on that second image, it looks like it does what you want.