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.
Looking at the disk statistics – there were more than 200 GB of attachments and growing.
So we decided to take 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 the most disk space.
select top 10 '[' + CONTENT.TITLE + '|https://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 13 GB. 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 that 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 – It’s an advanced issue synchronization solution that supports cross-organization issue tracking.
Its flexibility comes from the built-in groovy scripting capability, allowing it to implement almost any type of integration.
Do you need support?
You can always contact us to help out with the implementation of your use cases.
