How do I retreive Confluence content for a deleted Active Directory user?

Our Confluence instance is connected to MS Active Directory for user management. We have a user that has created content in the wiki, then their AD account has been deleted. Now their content has disappeared from view in the wiki.

Please help - we'd really like to not have all our users' content deleted/unavailable when they're deleted from AD.

Is there some way of stopping the content from disappearing (and to recover the content that already has)?

I see this is related to and . Still need an answer for my current problem though...

2 answers

Hi Brett,

I don't think the content is really lost. Check in your database. Perform the following query to check if the content is still there:

SELECT * FROM content WHERE CREATOR = '<AD username>' OR USERNAME = '<AD username>';

This should show a list of content items for that specific user.

This way you should also be able to recover the content that seemed deleted. But I would not recommend editing the database by yourself. Call Atlassian Support to help you with that (

Hi, from my experience, deleted/inactivated user's personal data can be accessed. i tried couple of options. they worked.

either of them should work:


<confluence-url>/display/~username/home - if user does not change the default home page

from my observation, this url pattern will not work for inactivated users <confluence-url>/display/~username



Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

1,131 views 61 8
Join discussion

Atlassian User Groups

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!

Find my local user group

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

Groups near you