Confluence 4.0 : Finding Unused Spaces
This page last changed on Sep 15, 2011 by pwatson.
Sometimes, you want to know what is not being used. It's great to know what's getting most attention, but what about stagnant pages, or even entire spaces that are no longer active? While viewing space activity can provide hints, it doesn't always provide enough detail. The simple way is to go directly to the database. We recommend DbVisualizer, and have basic instructions for connecting it to HSQLDB. SELECT spaces.spacename, MAX(content.lastmoddate) FROM content, spaces WHERE content.spaceid = spaces.spaceid GROUP BY spaces.spacename; It returns a list of spacenames, and the last date and time at which any content was added or changed. 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. 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. |
![]() |
Document generated by Confluence on Sep 19, 2011 02:38 |