Finding Unused Spaces
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.
The following query identifies the last date on which content was modified in each space within a single Confluence instance:
It returns a list of spacenames, and the last date and time at which any content was added or changed.
Alternatively, this one simply identifies spaces whose content hasn't changed since a specified date:
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
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:
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.
Was this helpful?
Thanks for your feedback!