08-20-2016 10:15 AM
Can anyone provide the AXL syntax to perform a bulk change of the userID attribute in the CUCM 11.x enduser table? I have used the executeSQLUpdate syntax in DOC-44206, but that updated a single record. I'd like to pull the old user ID and new user ID values from a .csv or .sql file (or other bulk method) if possible. I have about 4000 records to update, so the fastest and most efficient method would be ideal. My SQL skills are pretty limited and I'm new to AXL - assistance would be greatly appreciated.
08-24-2016 02:11 AM
you can have a look at the sqltoolkit from cucm
alternatively I have a commercial tool that can do about any bulk axl add/update/delete
08-24-2016 06:21 AM
I found a different reference on how to chain the update commands into a single sql statement. I still need to break it into smaller bits to keep it manageable but it works.
Out of curiosity, what's the commercial tool?
09-13-2016 06:13 AM
Robert, I wrote a script that can do this in perl. Hopefully you can use it: The AXL interface will accept control characters like linefeeds and that which are a bad time if you put them in by accident. I stripped them out below. Hopefully this serves as a framework for you to do what you need, or others. Particularly this comes in handy when you're migrating to establish a LDAP sync, and you want to get your userIDs to line up.
The forum editor is doing its best to ruin this so I have attached it.
09-19-2016 01:40 PM
Thanks Adam. I am, in fact, attempting to converge the user IDs with AD SAM account names prior to an LDAP sync.
03-19-2019 01:35 PM
Hi Adam...I successfully tested your script in my lab. Thanks for sharing! I'm curious if you had any recommendations for running in a production environment. Specifically, if there are any performance impacts to CUCM when running script to update hundreds or thousands of users in one run?
03-19-2019 02:28 PM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide