Find Drafts from all Users

We recently ran into a problem in which an employee left our company and we lost some documentation for a team. Our confluence instance is tied to AD, so his account was deactivated. I ended up going through the AD team to reactivate his account, reset his password, then log in as him in order to see his drafts (which in turned allowed us to save some other content he had started but not saved). Is there no way for a Confluence administrator to view drafts for a specific user? That feature would be incredibly helpful.

2 answers

1 accepted

4 votes
Accepted answer

Hi Mark,

I couldn't find this possibility in Confluence embedeed functionalities, so I've created this feature request for you here:

I recommend to vote and also comment in that request ticket to increase popularity.



Hey Mark,

Besides Rodrigo's feature you can also use the following method to get ownership over the drafts:

  1. Take a backup of your database for safety measures.
  2. First Shutdown Confluence.
  3. The run the query -  "SELECT * FROM user_mapping where username = 'target User'"
  4. Take note of the target user_key.
  5. Then run the query - "SELECT * FROM user_mapping where username = 'my user'"
  6. Now take note of your user_key.
  7. After that run the final query:
update CONTENT SET CREATOR = 'your user key'
where CREATOR = 'target user key'

After you do that, all the drafts of the target user will be moved under your user at Profile Picture > Drafts, with that you will be able to resume any edits of that user since they will now belong to your user.

Hope it helps.

Thanks and Regards,
David| The Engineer that like Windows for realsies.


That's great there's a backend way to do this, but that requires additional individuals with whom I already struggle to get their time. Plus, as the main admin and content creator, I have a lot of drafts already in my profile (is there a way to delete all drafts for a user through the UI rather than deleting one at a time?). I'm surprised this feature hasn't come up before.

I'm afraid not my friend :(., to delete the drafts we would also require database manipulation, if you want to know how let me know so I can build the other query.

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

895 views 45 7
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