Our Confluence Server instance is starting to see some significant increase over the past few months with attachment usage, and I'm a bit unsure of the best way to go to get an idea of how we can either go through and delete/archive attachments that haven't been accessed in x period of time or even get an idea of attachment storage per user so we can reach out to the teams they belong on to validate that all the data they've uploaded is still necessary.
Any advice on what's worked with attachment analytics or archival to help ensure we aren't just retaining stale data or being able to get on overview of the biggest attachments/etc?
I don't have a way to report on attachments by user but you can start by finding the largest attachments and seeing whose pages they are on: How to find the largest attachment files in your Confluence instance
Also, on this page: How to get more statistical data (disk space, contents created) from Confluence's usage there is a query to find the total size of attachments (in bytes) in all pages / blogs in each space.
Hopefully you can extrapolate who the users are from the permissions on the larger spaces.
Please let me know any follow up questions.
A colleague saw your question and let me know about this query that will identify files that are used in more than one place. If you see anything unusual in the results it could indicate a page with lots of attachments being copied multiple times, etc:
SELECT title, COUNT(title)
WHERE contenttype = 'ATTACHMENT'
GROUP BY title
HAVING COUNT(title) > 1
ORDER BY COUNT(title) DESC;
👋 Hello Community! My name is Stephanie Zhang, and I’m a product manager on the Confluence cloud team. Today, I’m excited to announce the rollout of Presenter Mode : a ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events