list of pages being edited

[Ruud Grosmann]

I have to migrate confluence to another machine. Is it possible to get a list of pages being edited, so that I can warn the individual users to save their work before the export of the data really starts?

thanks, Ruud

[Ruud Grosmann · Accepted solution]

It can be done with this query on the confluence database:

select creator from content where CONTENTTYPE='DRAFT' and creationdate >= (now() - interval '1 day');

or similar

[Boris Georgiev _Appfire_]

Currently this does not seem to be possible - see this open issue https://jira.atlassian.com/browse/CONF-4943

You may try to implement somthing custom through the confluence API by calling findDraftsForUser(com.atlassian.user.User user) from com.atlassian.confluence.pages.DefaultDraftManager

[Ruud Grosmann]

I have had a good look at the drafts tables in the confluence database, but they don't seem to be updated when I open a page for editing. I use confluence 3.5.9, maybe in that version drafts are not stored in the database.