Consolidated/Master List

[Leigh Morissette]

Is there a way to get a consolidated list of all of the spaces to include the space description, whether or not the space is active or archived, who the administrator of the space is, etc.? Currently to get this information, we have to open up each individual space and gather the information that way. It would be much easier and less time consuming if we could have all of this information in one place.

[Guilherme Nedel [Atlassian]]

Hello Leigh,

Talking about bundled options, the Usage Tracking plugin can show the top active spaces. For archived spaces - there is an homonym feature in Confluence - they will show up in the Archived Spaces tab.

edit: you may use the following against the DB to check for recently updated content:

SELECT spaces.spacename
FROM content, spaces
WHERE content.spaceid = spaces.spaceid
GROUP BY spaces.spacename
HAVING MAX(content.lastmoddate) < '2014-08-10';