when making an entry in Cisco Unified CM Administration under user management the under end user there are occasions where after I click save the error comes back explaining there is already an extension that matches the one I entered. with that the system adds a *01 to the end of the extension to make it unique.
I am trying to figure out how I can correct this error when it pops up.
OK, if I'm understanding what you're saying, you want to find out where the self service ID you're trying to use is already in place??
You'd need to BAT export the users to find that out.
Or you want to somehow change the *01 prefix?? because that I don't think is configurable.
I need a BAT export? Where can I do that? How do I do that?
Also that is going to give me a list of users and their information. if I'm understanding what you're saying, after I generate this list I then have to search the list and find the double entries. Once I have all the double entries I then have to research each entry to decide which is the active one. Now that I have that what do I do....
A simple SQL query from the CUCM CLI can tell you which user has a particular Self-Service User ID.
The "keypadenteredalternateidentifier" column in the "enduser" database stores the "Self-Service User ID".
The following query can be used to give you the User ID of the account with a Self-Service User ID of 1234.
run sql SELECT userid FROM enduser WHERE keypadenteredalternateidentifier like '1234'
I just tried it out on a UCM 11 cluster and it worked fine (output below).
admin:run sql SELECT userid FROM enduser WHERE keypadenteredalternateidentifier like '1234'
Once you have the User ID you should be able to find it easily on UCM Web Administration.
Let us know if this helps.
You aren't crazy. I know it can be frustrating trying to solve a problem without the correct level of access.
As far as I know there is no relatively easy method of searching by Self-Service User ID other than the SQL method, or the Bulk Administration method that Jamie mentioned.
However, in CUCM Version 11 they introduced the ability to search by "Meeting Number", which pulls from the Self-Service User ID. If you are running this version you can easily search by the Meeting Number to find the user with a specified Self-Service User ID (example below).