Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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.

3 answers

1 accepted

4 votes
Answer accepted

Hi Mark,

I couldn't find this possibility in Confluence embedeed functionalities, so I've created this feature request for you here: https://jira.atlassian.com/browse/CONF-35921

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

Cheers,

Rodrigo

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'
and CONTENTTYPE = 'DRAFT';

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.

[comment deleted by author]

Suggest an answer

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

Announcing Team Calendars in Confluence Data Center

Hi Community! We're thrilled to share that Team Calendars for Confluence is now a built-in feature for Confluence Data Center releases 7.11 and beyond.  A long time favorite,  Team Cale...

113 views 0 3
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