|
Alternatively, this one simply identifies spaces whose content hasn't changed since a specified date:
SELECT spaces.spacename FROM content, spaces WHERE content.spaceid = spaces.spaceid GROUP BY spaces.spacename HAVING MAX(content.lastmoddate) < '2006-10-10'; |
The result is a simple list of space names.
It's also possible to present the information in a wiki page, using the SQL plugin, which can be installed using the Plugin Exchange. You'll also need to define a database resource in conf/server.xml and confluence/WEB-INF/web.xml, as described here. Having done so, you can use wiki markup code like the following, replacing confluenceDS with the name of your own local datasource:
h3. Space activity
{sql:dataSource=confluenceDS|output=wiki}
SELECT spaces.spacename AS Space, MAX(content.lastmoddate) AS LastModified
FROM content, spaces
WHERE content.spaceid = spaces.spaceid
GROUP BY Space;
{sql}
|
The result will be something like this:

You can try the Chart plugin in combination with the SQL plugin to give more visually attractive results.