Space Size

HopeJ

Is their any way to see the size of a confluence space, number of attachments etc.

Alex Holtz

Easiest way that I know of is to use direct SQL queries against the database.

1) Install the SQL and Cache plugins for Confluence
2) Install the macro-security plugin for confluence and restrict SQL to admins only
3) Configure a datasource in your <install>/conf/server/.xml config file with a read-only user that has access to the confluence database.
4) Create a wiki page and add the markup to query and render the results directly in the wiki page:

This macro will render a table with three columns: | page total | space name | space key |

{cache}
{sql:dataSource=confluenceread|output=wiki}
select count(distinct CONTENT.title) as "Pages", SPACES.spacename as "Space", SPACES.spacekey as "Key" from CONTENT, SPACES where CONTENT.spaceid IS NOT NULL and CONTENT.spaceid = SPACES.spaceid group by CONTENT.spaceid order by Pages DESC
{sql}
{cache}

This macro will render a pie chart and a table that displays the totals across you entire site for: Pages, Attachments, Comments, Mail, Drafts, and User Status. You should be able to modify the query to select only from specific spaces quite easily:

{chart:title=Confluence 
Content|type=pie|displayData=true|width=500|height=300|dataOrientation=vertical|pieSectionLabel=%0%
 - %1%|legend=false|tables=content | attachment=^Confluence Content.png |
 attachmentVersion=replace}

{sql:dataSource=confluenceread|id=content}
select contenttype as Type, count(distinct CONTENT.title) as "Count" from CONTENT group by contenttype having Count > 0
union
select contenttype as Type, count(*) as "Count" from CONTENT where 
contenttype='COMMENT' group by contenttype having Count > 0
union
select "ATTACHMENTS" as Type, count(distinct title) as "Count" from ATTACHMENTS having Count > 0
order by Count DESC
{sql}
{chart}