Confluence Docs 3.0 : How do I... find unused spaces
This page last changed on Nov 20, 2007 by jfleming.
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 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} !DOC:How do I find unused spaces?^SQLscreenshot.png! The Chart plugin can be used in combination with the SQL plugin to give more visually attractive results. |
![]() |
Document generated by Confluence on Nov 05, 2009 23:34 |