批量修改crowd用户邮箱后缀

3步：
1）先找到目录ID
SELECT id FROM cwd_directory WHERE impl_class = ‘com.atlassian.crowd.directory.InternalDirectory‘;

2）将域名和目录ID写入

UPDATE cwd_user SET email_address = replace(email_address,‘<PreviousDomain>‘,‘<NewDomain>‘) WHERE directory_id = <ID from step 2>;
UPDATE cwd_user SET lower_email_address = replace(lower_email_address,‘<PreviousDomain>‘,‘<NewDomain>‘) WHERE directory_id = <ID from step 2>;

3）重启crowd

延伸阅读：
https://confluence.atlassian.com/crowdkb/how-to-change-all-crowd-internal-users-e-mail-domain-name-in-bulk-720831515.html

批量修改crowd用户邮箱后缀

原文：https://www.cnblogs.com/ccielife/p/12401216.html