Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

Update Line Information via CUCM BAT Tool

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


5 REPLIES
Hall of Fame Super Silver

Update Line Information via CUCM BAT Tool

You can develop a SQL update query to do this from CLI, let us know exactly which field you want to update.

Chris

Community Member

Update Line Information via CUCM BAT Tool

Hello Chris,

Thanks for your help!

I want to update the "Line text label"&"ascii line text label" in every phone's line1.

Thanks.

Hall of Fame Super Silver

Update Line Information via CUCM BAT Tool

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 with the extension of the DN you want to change it for.

HTH,

Chris

Community Member

Do  you know any SQL update

Do  you know any SQL update command to set DN's recording profile to enable and assign a recording profile?

 

Thank you. 

Bronze

With version 9.1 and higher.

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. 

 

534
Views
0
Helpful
5
Replies
CreatePlease to create content