I have a large group of users that came over in an import - local users. We're using LDAP. To disable them all, it takes a long time as for each person I edit and make inactive, the screen has to reload the search results. I was thinking it would be easier to do a query in the DB and update them that way.
I found this but I wanted to make sure it didn't inadvertently in-activate any LDAP accounts so I wanted to add a qualification for that (if there is something that tells you if the account is LDAP or local).
update
cwd_user
set
active = 0
where
user_name
in
(test1, test2);
I was going to change it to this:
update
cwd_user
set
active = 0
where
user_name
like 'c_%';
Has anyone done this?
Hello Shannon,
Users from your LDAP and Local JIRA users have specific directories ids. You can check with the query:
SELECT * FROM cwd_directory
Now that you already know their directory ids, you can just run the query:
UPDATE
cwd_user SET
active = 0
where
cwd_directory = (directory id from users you want to set as inactive users)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.