11-10-2013 01:04 AM - edited 03-16-2019 08:19 PM
Hello,
I want to update one information in LINE by BAT.
My CUCM is 9.1.2.
Because I want to add the "line text label" in everyphone.
But only setup the same value by Phone -> Update phone.
I cannot upload one CSV file, and config the difference name in ervey line.
How Could I do about it?
Thanks for your help. ^^
11-10-2013 06:48 AM
You can develop a SQL update query to do this from CLI, let us know exactly which field you want to update.
Chris
11-10-2013 07:30 AM
Hello Chris,
Thanks for your help!
I want to update the "Line text label"&"ascii line text label" in every phone's line1.
Thanks.
11-10-2013 07:53 AM
From CLI run:
run sql update devicenumplanmap set (label, labelascii) = ('whatever', 'whatever') where fknumplan = (select pkid from numplan where dnorpattern = '
create a text file with multiples of these wherer you replace the "whatever" as your desired label and
HTH,
Chris
05-27-2015 03:05 PM
Do you know any SQL update command to set DN's recording profile to enable and assign a recording profile?
Thank you.
05-27-2015 05:04 PM
With version 9.1 and higher..maybe 8.6 I cant remember it is very easy to do what you want without a SQL anything... Ill log int oto work later and confirm the settings below...
BULK ADMIN - Update Phones - Update Lines
Filter what you are looking for if you need to by device pool or one of the other variables.
Recording profile is down towards the bottom , just like it is normally.
Check the box next to that setting to make sure it is applied.
Bottom of the screen gives you the option to run the job immediately or delay it.
08-12-2019 01:36 PM
@Chris Deren what would the sql string look like if i wanted to update the Display (Caller ID) of a line?
08-12-2019 02:40 PM
Something like:
update devicenumplanmap set (display, displayascii) = ('Micheal Jordan', 'Micheal Jordan') where fknumplan = (select pkid from numplan where dnorpattern = '5555')
08-13-2019 06:01 AM
@Chris Deren That's fantastic! Thanks for your help!
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