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.