A simple way to monitor attachment size usage on confluence

One of our customers called us because the confluence disk was full and they wanted to stop adding disk space all the time.  They needed a way to monitor the way that confluence is using disk space.

 

hd-1

 

Looking at the disk statistics – there was more than 200 GB of attachments, and growing.

So we decided to have a look at what page was consuming the most disk space using the following query (this is SQL Server 2005) which extracts the pages requiring most disk space.

select top 10 '[' + CONTENT.TITLE + '|http://confluence/pages/viewpage.action?pageId=' + convert(varchar(10),ATTACHMENTS.PAGEID) + ']', round(SUM(ATTACHMENTS.FILESIZE) / 1073741824, 0) as GB
from ATTACHMENTS inner join CONTENT on ATTACHMENTS.PAGEID = CONTENT.CONTENTID
group by ATTACHMENTS.PAGEID, CONTENT.TITLE
order by SUM(ATTACHMENTS.FILESIZE) desc

Queries for other database systems will vary

 

It turned out that one page was using 13GB. One excel attachment had 2450 versions. The team was using excel as a file server, editing the excel file in place.

(don’t do that, there are better file server systems than confluence)

Monitoring

We now created a page which is used to monitor the total attachment size. It is easy to do. Install the excellent Bob Swift SQL Pro add-on (check the marketplace listing here) and add the query to the page


Are you still using multiple issue trackers?

Check out exalate http://www.exalate.com – Exalate is an advanced issue synchronization solution which supports cross organization issue tracking.
Its flexibility comes from the built in groovy scripting capability allowing to implement almost any type of integration.

Support anyone ?

You can always contact us to help out with the implementation of your use cases, just contact us.

Leave a Reply

Your email address will not be published. Required fields are marked *