Bulk User Deactivation in Jira

# TOTAL LDAP USER COUNT
SELECT count(*) from cwd_user where directory_id = 3;

# LDAP ACTIVE USERS
SELECT count(*) from cwd_user where directory_id = 3 AND active = 1;

# LDAP INACTIVE USERS
SELECT count(*) from cwd_user where directory_id = 3 AND active = 0;


# INTERNAL ACTIVE USER COUNT
SELECT count(*) from cwd_user where directory_id = 1 AND active = 1;

# INTERNAL - INACTIVE USER COUNT
SELECT count(*) from cwd_user where directory_id = 1 AND active = 0;



# DEACTIVATE ALL INTERNAL ACCOUNTS
UPDATE cwd_user SET active = 0 WHERE directory_id = 1;

# ACTIVE YOUR INTERNAL JIRA ADMIN ACCOUNT "jira-admin"
UPDATE cwd_user SET active = 1  where user_name = "jira-admin";



# DEACTIVATE LDAP ACCOUNTS
UPDATE cwd_user SET active = 0 WHERE directory_id = 3;

# ACTIVATE YOUR JIRA-ADMIN LDAP ACCOUNTS
UPDATE cwd_user SET active = 1  where user_name IN ("jlopez", "jsmith");