Bulk delete JIRA users from SQL database

[BA_Honeywell]

Team,

We need to perform a user cleanup in our JIRA instance that uses SQL database. We would like to know if we can delete the users from databse table cwd_user directly.

Thanks.

[Nic Brough [Adaptavist]]

Absolutely not.

Unless you are 100% sure you have captured and updated all the places a user id might have been used or it will try to refer to defunct user records and fall over in a steaming heap (you'll be reaching for backup tapes). 18 different tables last time I looked. Reporter, assignee, custom fields, watcher, voter, component and project leads, comments, the list goes on and on.

It would be far better to *attempt* to delete users with a Jelly script - that will delete users, but only the ones it is safe to delete