Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,268,031
Community Members
 
Community Events
164
Community Groups

Best method for auditing/archiving/deleting attachments on Confluence?

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?

1 answer

1 accepted

2 votes
Answer accepted
AnnWorley Atlassian Team Apr 10, 2018

Hi Rory,

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.

Thanks,

Ann

Thanks Ann - this should be helpful to start with!

AnnWorley Atlassian Team Apr 10, 2018

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)
FROM CONTENT
WHERE contenttype = 'ATTACHMENT'
GROUP BY title
HAVING COUNT(title) > 1
ORDER BY COUNT(title) DESC;

Like Gabriel Points likes this

Thanks again - we'll run the queries to see what we can come up with in the short term.

Hello jhon.

 

My question focuses on how the data deletion process is carried out on cloud platforms after unsubscription and the retention period ends. What methods do they use? how is the proccess?regards.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Confluence Cloud

Presenter Mode for Confluence is here 🖥 👩‍💻

👋  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 ...

65,244 views 98 247
Read article

Community Events

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

Events near you