Confluence Docs 3.3 : Finding Unused Spaces
This page last changed on Sep 22, 2008 by jnolen.
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 and the Global Statistics plugin can provide hints, they still don'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 Jul 09, 2010 01:08 |