nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Confluence Attachments

Christopher Can1

Hello,

I have Confluence setup with attachments stored in a file system. I need to perform a cleanup of this system to free up space. Is there a way to do a search to find attachments in confluence file system that are no longer referenced on any Confluence page?

Also, is there a way to search througha list of of the biggest attachments and see what Confluence space or page they are being referenced in?

Accepted answers

NotTheRealStephenSifersNOPENOPENOPENOPE

There is a SQL query you can run in the back end to show attachtments with size:

use Confluence
select TITLE, PAGEID, FILESIZE/1024/1024 as MB
from dbo.attachments
order by FILESIZE DESC

All comments

NotTheRealStephenSifersNOPENOPENOPENOPE

There is a SQL query you can run in the back end to show attachtments with size:

use Confluence
select TITLE, PAGEID, FILESIZE/1024/1024 as MB
from dbo.attachments
order by FILESIZE DESC

Christopher Can1

Thanks, I had already ran that query. I have the full list, the problem I am running into is I need to know which attachments are no longer referenced (not needed and can be deleted) and then for the remainder I need to find a way to see what Space the active attachments are being used in.

Thanks,

Chris

NotTheRealStephenSifersNOPENOPENOPENOPE

When a space or page is deleted, the attachment is then removed from the space or page.

I am doing a little more digging to get you something a little more focused.

NotTheRealStephenSifersNOPENOPENOPENOPE

I am not finding an easy way to pull data from SQL to tell when an attachment is referenced within the page. The issue being there is more than 1 way to reference an attachment and multiple macros (not including custom ones) that also take advantage of an attachment.

The attachment page within a page is still part of the page itself, and even if an attachment is not referenced outside of the attachment page it is still technically used.

The best idea I can come up with for this one would be to delevlope a script to crawl through all attachment names and ID and scrub the pages to see if it's referenced.

But the issue with this is maybe an attachment is placed on a page for a reference or archive purposed. Granted storing items as an attachment for an archive is not a good idea, but that doesnt stop people from doing it.

Simply put, this will not be easy to complete but would be cool to see how you do it!

jing_hwa_cheok

Hi Christopher,

I believe this is what you are looking for http://ffeathers.wordpress.com/2013/06/02/how-to-manage-attachment-usage-in-confluence-wiki-with-some-python-scripts/. You can usethe python script there to find orphaned attachment.

Regards,
Jing Hwa

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

confluence-administration

attachment