Process for Confluence cleanup

[Dan Campbell]

We will be performing some cleanup within our Confluence installation
Our Plan
Set users to inactive in the database -- we have identified 25868 users that need to be set to inactive
we will be using the following script to perform  this:
UPDATE cwd_user SET active = 'F' WHERE user_name in (xxxx,xxxxx)

We also found that of these users, 95 of them have Personal Spaces
We will delete the Personal Spaces through the UI

We also found that 37 Global sites will not have an admin once we set these users to inactive
The unused spaces will be deleted through the UI

Questions:

would it be best to set the users to inactive prior to the deletion of the spaces, or delete the spaces first?

Does anybody see any issues with the process?

Thanks

[Tyler Brown · Accepted solution]

Hey Dan,

Not sure if there would be any issues with marking them inactive first for Confluence.

I do know that when you mark a user inactive it becomes difficult to search for the user in JIRA (not sure of the same issue would apply in Confluence though. May be best to delete all of the relevant Confluence data first and then remove the users.

Tyler

[Andra Dinu]

Bit late to the game,  but take a look at this 6 step process you can adapt to your own Confluence Cleanup needs: https://www.adaptavist.com/blog/how-to-clean-up-confluence-in-six-steps/
This was written based on our experience with multiple customers and users of our apps. 

(I work in Marketing for Adaptavist)