CUCM Inactive LDAP Users to Active LDAP Users
There might be some certain requirements when you might asked to convert Inactive LDAP Users to Active LDAP Users and then Convert them into Local Users in Cisco Unified Communications Manager (CUCM). If yes, then below steps will help you to make Inactive LDAP User to Active LDAP Users.
If you want to convert LDAP End Users from Inactive to Active, enter the following command –
run sql update enduser set status=1 where userid like ‘A%’
*** Note – If your End User ID starts with the letter A use the same command, else replace A with a letter that your End User starts with. If you would like to use query like Last Name or Department or Telephone Number etc instead of userid, you can replace userid with the following.
Last Name = lastname
Telephone Number = telephonenumber
Department = department
Example – run sql update enduser set status=1 where telephonenumber like ‘9%’
If you want to convert LDAP End Users from Active to Inactive, enter the following command –
run sql update enduser set status=2 where userid like ‘A%’
Note : In the above set of commands, if you put the numeric value for status=1, it will make the End User LDAP Account as Active and If you put the numeric value for status=2, it will make the End User LDAP Account as Inactive.
To convert an Active LDAP User into a Local User in Cisco Unified Communications Manager, follow the below link –
https://www.uccollabing.com/2016/06/20/convert-ldap-users-to-local-users-in-cucm/
Hope this helps!!
I am working in an IT company and having 10+ years of experience into Cisco IP Telephony and Contact Center. I have worked on products like CUCM, CUC, UCCX, CME/CUE, IM&P, Voice Gateways, VG224, Gatekeepers, Attendant Console, Expressway, Mediasense, Asterisk, Microsoft Teams, Zoom etc. I am not an expert but i keep exploring whenever and wherever i can and share whatever i know. You can visit my LinkedIn profile by clicking on the icon below.
“Everyone you will ever meet knows something you don’t.” ― Bill Nye
