This SQL query can help to change all the users from ldap integrated toactive local state.
a. Make sure that LDAP integrated users are "Active ldap integrated users". Then run the following query on the CLI of the publisher.
b. run sql update enduser set fkdirectorypluginconfig = null where fkdirectorypluginconfig != ''
c. After that if you go to end user GUI page, the user will show as "Active local user".
d. To confirm that no user is in "inactive state". run sql SELECT pkid,userid,deletedtimestamp FROM EndUser WHERE status=2
Note: This will run for the full enduser table. So, it will change all the users which are ldap integrated to local. Use it only when we need to convert all the users to "active local user" state.
++++++++++++++++++++++++++++
在11.5 的CUCM上测试有效。转换成本地用户之后就可以删除用户。
之后重新连接LDAP同步,被转换的local用户自动变成了LDAP用户。