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.

Super Bronze

Update UserID via AXL?

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
1 ACCEPTED SOLUTION

Accepted Solutions

Re: Update UserID via AXL?

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

2 REPLIES

Re: Update UserID via AXL?

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

Super Bronze

Re: Update UserID via AXL?

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...

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
180
Views
5
Helpful
2
Replies