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 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)
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.