Is there a way to automatically disable Confluence users that have been inactive for a given

Question

I'm investigating if there is a way to disable users that have not been active in Confluence for 90 days, using a script. I'm working with our development Confluence instance. Using SQL developer I see there is a table CWD_USER that has column ACTIVE for each USER_NAME row, and that ACTICE is set to 'F' (false, as opposed to 'T' true) when a user is shown disabled in Confluence. However if I set ACTIVE to be 'F' in SQL when it was 'T' then the user does not show as disabled in Confluence. I guess it's not that simple? Is disabled also dependent on one or more other columns in other tables?

The Confluence version is 7.19.1. I am an admin.

Chris Shaw_n2cr8t · Answer

Hello @Trudy Claspill we use Microsoft Active Directory

Chris Shaw_n2cr8t · Answer

Thanks but I was trying to avoid spending money on a plugin for it. We need the automation to be done regularly

Ed Letifov _TechTime - New Zealand_ · Answer

Hello, @Chris Shaw

Just use our UserManagement for Confluence on an evaluation license if it's a one-off.

You will be able to perform bulk deactivation using Bulk User Actions screen in the UI, no scripting or SQL required.

If this is something you want to be regularly and automatically, consider purchasing a license, and configuring a scheme in the Scheduled User Actions instead.

If you have any questions don't hesitate to reach out to our 24x7 support.