Re-validate all users

[Giovanni Tirloni]

Over the years we have accumulated a lot of cruft in the form of users that we don't know if they are real users or dormant spambots.

Is there a way to ask all users to re-validate their access and disable everybody else?

[Guilherme Viana · Accepted solution]

Hi Giovanni, you can filter the last time your users accessed Confluence as stated by doc, take their IDs, and deactivate them with the following query:

update cwd_user set active = 'F' where id in (xxxx,xxxx,xxxx);