08-18-2008 10:49 AM - edited 03-13-2019 05:34 PM
Hi
I have a need to change the userID of a large number of users on a CM6.1 system.
Obviously pre-CM5 you couldn't change the userID, but on the linux versions you can.
I've reviewed the AXL API docs, but it doesn't appear to have been updated to include the ability to rename the UserID field.
Is this correct, or is there a way of doing this?
Thanks
Aaron
Solved! Go to Solution.
08-18-2008 12:45 PM
Hi Aaron,
I haven't tried it myself but I guess you can use executeSQLUpdate on the enduser table?
I reckon you should extract all users and use the pkid to update userid
hth
08-18-2008 12:45 PM
Hi Aaron,
I haven't tried it myself but I guess you can use executeSQLUpdate on the enduser table?
I reckon you should extract all users and use the pkid to update userid
hth
02-11-2009 03:18 AM
Update- I was able to do this, submitting a SQL update via AXL.
There's no other native way in the AXL API yet to submit a userID change, I think this is a legacy problem as in CM4.x the UserID couldn't be changed!
I've done this for a couple of customers for large numbers of users, and haven't had any problems - EM and other things related to the user all continued to work so it doesn't break the DB.
The easiest way to do it is to get the axlSqlToolkit from the CallManager Plugins download page. Edit the sample.request to contain lines like this:
Please rate useful posts...
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: