I have added a vote for this.

Any enterprise system with multiple users and employees who come and go MUST support the company that owns the system and pays its employees to document access to everything.

Once an employee enters data in Confluence, the company owns that information, which is regarded as IP.
I'm all for security; however, a company admin should always be able to access everything: all drafts, all restricted pages, and everything else.

TIA

Can someone share the SQL query to get the drafts older than 6 months?

• 394.206 (# of regular Drafts Attachments older 6 months)
  • Potential free-up Space from FS ~184GB
• It's Crazy that no mechanism from a tool is given to provide this basic feature... built in, instead of DB deletion and corresponding FS removal
• A disappointment and typical, a pressure to cloud, once more...

We just discovered 50,000 drafts (plus 180,000 associated attachments) in one of our instances, so yes please - either allow admins to see all the drafts without going into the database, or allow us to set guardrails that remove drafts that haven't been touched in X amount of time.

+1 to make it happen

Running into issues with this again. Hidden drafts that need to be deleted before pages can move between spaces, and we've got to try and get the person who created them to delete them rather than just have an admin delete them.

Waste of everyone's time.

https://getsupport.atlassian.com/browse/CSP-318050

The reason we care is that a page with an unpublished child has a drop-down arrow next to it in the left-hand navigation pane; but clicking on that arrow does nothing, because there are no new pages to display (because they are only in draft).

So Confluence knows that draft exists; it just chooses not to allow Admins to see it because... ?

9 years ago someone posted a series of database commands you could use to assign one person's drafts to yourself, so you could edit and delete them. 9 years later Confluence is still unable to provide the most basic controls. Oh, right, because someone wrote an app to fix it.

If you added up all the apps you need to buy to fix the basic bugs in the simplest use of Confluence, I wonder how much the monthly user fee would be?

We are in the middle of a large migration to confluence cloud. Not having this feature means we are moving 10's of thousands of unpublished (and likely empty) pages to the cloud, costing us real, measurable downtime and money.

Having this ability would have allowed our admins to do a massive cleanup and saved us tons of time, money and risk avoidance.

If the company is writing such a term, it should be possible, I think.

After Collaborative editing reboot, this draft feature messed up peoples edit modes - I do not know how, but I feel that these drafts somehow became a problem for edit mode for lot of pages.

If I could somehow delete all drafts - to be honest, this draft has been more pain than help - "my edit mode is broken - it does not show the same content as my page does" is my everyday life!

If I just could simply delete all drafts or if I could do it for person having an issue, would be much help.

If you have access to the underlying database, and are comfortable with SQL, change the owner of the draft to yourself. It will then appear in YOUR drafts and you can choose to either publish it or delete it.

Hi community,

Please take a look and vote for another suggestion related to this issue - CONFSERVER-69247.
I believe we will not need to manage drafts manually if there will be some kind of configurable TTL after which abandoned drafts will be automatically removed with all attached content.

Whether you need to see what is in the draft is a different story.

It makes sense, though GDPR might have other requirements even from a page title visibility perspective 💁🏼‍♂️

^ it depends on how you interpret it.

In order to be able to delete drafts you will have to be able to see if user in question have drafts at all.

Whether you need to see what is in the draft is a different story.

If you yourself go to your own account list of drafts(which I fear not everyone is doing, after all their main job is likely not working with confluence) you are able to get to a list of drafts on one page. I'd say that ability to have list like that for admins and options to delete either all or let's say drafts that were not edited for more than 6months would do wonders...

And yes that page does not tell you what is on the page in detail anyway. 

Obviously before collaborative editing the story was different as drafts were bound to a space they were created in...

not to user.

Access to someone's drafts means that pages with limited access may be exposed to application administrators. I am not sure that this is the great idea. Otherwise the whole idea of page restrictions does not fully work.

Hi community,

I hope you don't mind this intrusion, but I encourage you to check out our new app.

We have come up with a solution for you to overcome the pile of drafts. You can check DraftMan for Confluence on the marketplace or go to the documentation site for more information.

Best regards

+1 this would be great

+1 It will be good

+1 this would be great.

Hello!
+1

Draft page persists in DB after moving page to another space by pageManager.movePageAsChild. This causes an issue while deleting old space, it fails until these "drafts" are removed from DB

Hello,

This feature is not usable for our situation. We have a lot of non-technical users who are not able to handle this kind of feature. They are "closing" changes which they do not want to be published. This would lead to a lot of wasted space in a short time period. We are only be able to update to the new confluence version be disabling this Collaborative editing.

Hello,

As for impersonation of an account one can always use ScriptRunner built in scripts if the plugin is installed.

//Tomas

Hello All

+ 1

Yes! +1 from us too. We have a large installation and have run into issues with orphaned drafts, as well as users leaving the company and having their AD accounts deactivated while drafts are left behind. Deleting all drafts via direct database access is absolutely not an option, given the amount of work in progress at any given time.

Yep, +1 from us too

We would require this feature enabled please if possible

+1

This feature would make our content management a whole lot easier.

Specially considering that since Confluence 5.7 a whole lot more document are left in draft mode due to editor 'Close' button that now save a draft of your page just in case you didn't mean to close the editor. Most users wanting to cancel an accidental create/edit of a document are left unaware that they now have a instance of the document in their draft mode.

Not only would this be useful if someone leaves the company and you need to access the content they were working on, but often editors leave a page in draft mode without realising it – maybe the browser crashes – if they don't go back in to edit the page, they don't see the resume editing option and might think that they published their changes. As the main Admin, it would be so helpful to be able to find any of those unpublished pages, if only to verify that there isn't any content on them that should be published. It would also be helpful as a check before final release of the space to ensure that all pages are finished and published. 

This feature could save me so much time!

I'd like to see this too myself. I have discovered so much old content from users (years old) and would love a way to "cleanup" and/or see if any of the content is still relevant to use