Confluence SQL query to delete users

[Jamie Edwards]

Hi

We need to do a cleanup of user accounts before migrating to Atlassian OnDemand. We have already managed to mark every user account that is inactive as disabled. Now we need to delete every user (1000+ of them) that has no content/contributions.

Wondering if anyone has already written such a query before we attempt our own.

[Davin Studer]

I wouldn't do it with SQL. I would use the official API's(SOAP/REST) for that. Another option would be to use the Confluence Command Line Interface. That way you know it is done correctly.

[Rodrigo Girardi Adami]

Hi Jamie,

We have a documentation here with some SQL commands to delete users from the database when it's not working from the UI. As Davin said, I wouldn't recommend doing it through the database, though easier, this can lead to data corruption if done incorrectly. Perform a database backup before any data modification, always!

Cheers,

Rodrigo