How can I get list of attachments on server sorted by size?

Question

I use standalone Confluence server on Linux.

Attachment's storage is default on file system.

What I would like to get is a list of files sorted by size from larger to smaller.

I can use linux utils for that by that gives me only size since all files have same "1" name under different paths.

WW · Answer

I'm ok with seeing the attachments in only one space and sorting by size.  However, there are 91 pages of attachments when I use the Space Attachments macro.

When I click the Size column header to sort, it doesn't work.  The sorting changes, but not to any recognizable pattern I can tell; not alphabetical, numerical, or combination thereof.

Looks like there's a known bug/issue for this.  With my vote, that makes 2. :(

CONFSERVER-56047

It did work for a smaller space with only one page of attachments, though.

Pavel Potcheptsov · Answer

Yes I can connects to database.

It looks like I can find filename from first table and it's size from second.

select TITLE, SPACENAME, round(concat(LONGVAL/1024/1024), 0) as Size
from CONTENT, SPACES, CONTENTPROPERTIES
where CONTENT.CONTENTTYPE = 'ATTACHMENT'
and CONTENT.CONTENTID = CONTENTPROPERTIES.CONTENTID
and SPACES.SPACEID = CONTENT.SPACEID
and CONTENTPROPERTIES.PROPERTYNAME = 'FILESIZE'
order by CONTENTPROPERTIES.LONGVAL DESC

Dominic Lagger · Answer

Out of the box, I don't know how that's supposed to work.

Here are two workarounds:

* Are you able to connect to the database? * The information is stored in the tables content and contentproperties (LONGVAL)

* Confluence Command Line Plugin (documentation). I don't know the plugin, but it seems, that there is a function, which gives you all attachments.