Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

Updating UserID field on enduser table on CUCM via sql

Hi,

I have a cucm cluster with local users (something around 1500 users) where the cucm users and the active directory users are complitelly different.

I have an excel file whitch have the active directory users and the cucm users respectively and I want to run an sql update command to update the users on the cucm to be the same as the active directory users and then make a LDAP sync on the cucm.

Someone can help me with the set sql update commant for this issue ?

Thanks,

Liran.

6 REPLIES

Re: Updating UserID field on enduser table on CUCM via sql

You could do this using AXL.

There is an updateUser Element

(https://developer.cisco.com/site/tech/communication-collaboration/management/axl/develop-and-test/documentation/latest-version/axl-soap.gsp)

You could program an application that reads the information from the excel sheet or a csv and sends a request for every user to CUCM.

Unfortunately I don't have a working example for this available.

Also have a look at the developer site:

https://developer.cisco.com/site/tech/communication-collaboration/management/axl/axl/

The XML-Request should look like this:

http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.5">

  

  

     

         enduser1

         newenduser1

     

  

New Member

Updating UserID field on enduser table on CUCM via sql

Hi,

Thank you for the response but I think that I didnt understand waht do you mean.

I know that I can do it with simple command for each user , so I preffer to do it on this way.

Does someone knows the exact command for update the userid ?

BR,

Liran.

Updating UserID field on enduser table on CUCM via sql

I have a sample perl script.

It is not exacly what you are looking for but can easily be changed.

It changes Call Forward All on a number of lines.

Therefor it reads a CSV file with 2 collums (line and CFA destination); generates a AXL request; sends it to CUCM.

It could be modified to change userid. The AXL request you will need is the one above.

Find the script here:

http://www.file-upload.net/download-8521718/Scripting.zip.html

New Member

Updating UserID field on enduser table on CUCM via sql

Hi,

Thanks for your effort.

I will try this and update you  .

Thank you ,

Liran.

New Member

Updating UserID field on enduser table on CUCM via sql

Hi,

Finally I used the next command:

run sql UPDATE enduser SET userid='New_UserID' WHERE userid='Old_UserID'

Liran.

New Member

Liran,

Liran,

How did you use this command for bulk updating the enduser table? Were you able to call the user ID variables from a CSV, or other, file?

/R

873
Views
0
Helpful
6
Replies