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

[Chris Shaw]

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.

[Ed Letifov _TechTime - New Zealand_]

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.

[Chris Shaw]

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

[Trudy Claspill]

Hello @Chris Shaw 

Are the user accounts created and managed in Confluence, or are you using another product for user management such as Microsoft Active Directory?

[Chris Shaw]

Hello @Trudy Claspill we use Microsoft Active Directory