How to get list of attachments for a space

Question

Hi,

I want to get a list of all the attachments in a space and get it into a CSV/Excel format. The key information I am after is the file name and the page name to which it is attached. If I use the Space Attachments macro - it is the perfect information, but it is listing them in groups of 20 and when I have a few hundred, I am going to have to cut-paste it a bunch of times to get it into CSV/Excel/Table format.

I want the output of that macro but in a big single table. I have also tried using search syntax such as - type:attachment AND spacekey:Key - it creates the search list, but again, not sure how to get that into a CSV/Excel/Table format.

Any ideas/suggestions that would be out of the box without using add ons?

Andy Heinzer · Answer

Hi everyone,

This post linked to another page which no longer exists as the reference of the answer.  However in Confluence Server/Data Center there is no out-of-the-box means to list all this info into a csv file directly.  The space attachment macro can be useful, but I understand that for large spaces with a lot of attachments, that makes creating a csv file daunting if you can only see 20 attachments at a time. There is a feature request for a means to increase the number of attachment that macro can display over in CONFSERVER-60196

That said, since this question seems to be for Confluence Server/Data Center, this level of information should be something that could be extracted from the database directly.   There is a KB over in How to search specific attachment type in Confluence which might prove useful.  Granted this is looking for a specific filetype, but you could adjust that SQL query to remove the last AND... from there you should be able to use it to return all the attachments within confluence along with info on which space they are in.

I realize this is not an out-of-the-box solution, but given the means by which confluence can restrict user's ability to view some content, this approach might be a more feasible solution as the SQL export of that data could easily be converted into a csv file.

Robby Holtmann_IntraFind Software AG_ · Answer

Hi @Dean Robinson

this is one of many features of our app "iFinder Confluence Search".

If you and your colleagues are also interested in a much better Confluence search, your CSV requirement is also solved with this.

Here is how it works:  Define your filters, go to CSV-export and define the metadate fields for CSV, export the search result list.

So, if you interested anyway on a high qualtiy search solution for Confluence, iFinder Confluence Search is available at Atlassian Marketplace.

It helps even the Confluence user without expert knowledge to search quite intuitively.

This enterprise search solution delivers top results based on linguistic analysis and offers many additional features.

These articles may help you:

• iFinder Confluence Search

• iFinder Search Macro

Let me know, if you need further information or like to get a demo first.

Best

Robby

Rodrigo _Elevatic_ · Answer

Good day @Dean Robinson,

Our team also saw the need to track and identify attachments and created the Attachment Report within Viewtracker.

This report provides information on how many attachments are in your instance and allows you to filter them by: date name, views, space, file size, unique viewers... and many more!

* Viewtracker - Attachment Report

As well as the possibility of exporting them in CSV form for further analysis in your preferred spreadsheet software.

We hope this is helpful and are always open to feedback :)

With friendly regards
Rodrigo