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?
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.
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!
You can do a search for null entries within SQL, but the issue is there is no page to delete them from since their not attached to a space or page. It's work a try.
To the above SQL just add "where PAGEID is NULL" between from and order. It may not work unless you LEFT OUTER join it with the content table and spaces table.
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.
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs