disable confluence users via sql

[maarten breesnee]

Hi,

I am in a team who took over confluence sys management. First of all we want to clean up all the users who haven't logged in for 6 months.

However its a lot of work to do this. Is there a safe query to do this?

[Amith Mathur {Appfire}]

Hi @maarten breesnee, 

You can retrieve the list of users who have not logged in since a specific date or by last login date. Please run the query, according to your confluence version, from this page.  

Once you do so, you can execute the below query to disable the users. However, it is advisable to do it through API or the UI. If you want to do it from the database, test it thoroughly in staging environment before doing so in the production. 

UPDATE CWD_USER set ACTIVE = "F" where user_name="userid";

Thanks, 
Amith Mathur

[Alexis Robert]

Hi @maarten breesnee, 

you can't bulk remove users like this directly in Confluence, but there is an addon that can do that if you want to give it a try. 

Let me know if you have any questions, 

--Alexis