Change all standard BLFs to new name:![]() Newer CUCM versions hide labelascii, so using: ![]() works fine, but will not replace previous existing labelascii Change all Alerting Names associated with a DN: run sql update numplan set alertingname='John Doe',alertingnameascii='John Doe' where dnorpattern = '82345' Change all Display Names to new user: run sql update devicenumplanmap set display='John Doe',displayascii='John Doe' where display = 'Mary Johnson' Change all devices that belonged to old user to new user: run sql select pkid,userid from enduser where userid = 'jldoe' or userid = 'mljohns' run sql update device set fkenduser='(string output from new kpid)' where fkenduser='(string output from old kpid)' Change the name of Remote Destination profiles and Jabber device profiles: run sql update device set name='CSFjldoe' where name='CSFmljohns' run sql update device set name='RDP_jldoe' where name='RDP_mljohns' Update or Add external masking to a user's phone: run sql update devicenumplanmap set e164mask='84300' where display = 'John Doe' |
Change all linked BLFs to new name: run sql select pkid from numplan where dnorpattern = '82345' ![]() |
Remeber you can always embed a select within an update like this: run sql update device set fkenduser = ( select pkid from enduser where userid = 'jldoe' ) where name = 'SEPA1B2A3B4A5B6' |