How to deactivate multiple jira users by programmatically (By any script)?

Question

unknown · Answer

Create a script that will deactivate the users:

1) Through the JIRA API https://docs.atlassian.com/jira/REST/latest/

2) Throught the database https://developer.atlassian.com/jiradev/jira-architecture/database-schema

Benito Picarelli · Answer

Hello Nanda,

You can query your database for users:

select * from cwd_user

and can simply change the "active" value to 0, instead of 1. This will automatically deactivate the user.

João Palharini · Answer

Could you specify the condition you would base the deactivation? I believe you may be able to achieve this through SQL (that is, if you are using JIRA Server).