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 Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

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

1,043 views 15 13
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