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. And see here for current known issues.

New Member

Bulk updating Alerting names in CCM5.1.2

Hi,

My customer has just decided (near project end!) that they'd like the names to show on the displays when an internal call comes in. I know this means that I have to configure the Alerting Name on each line. But with some 290 phones to do, is there a quicker way to do it?

I can't seem to figure out how to use BAT to accomplish this.

I'm not using AD.

Any help gratefully appreciated!

Dan

4 REPLIES
Silver

Re: Bulk updating Alerting names in CCM5.1.2

No (BAT) other bulk method would be a custom SQL query but that's unsupported.

Cisco Employee

Re: Bulk updating Alerting names in CCM5.1.2

i know it's not TAC supported but i did something similar a while ago with CCM 4.1(3)

i created this qry which copied the description that comes in the device config into the label for the line

update devicenumplanmap

set devicenumplanmap.label = device.description

from device

INNER JOIN devicenumplanmap on device.pkid=devicenumplanmap.fkdevice

In order to change the alerting name you would need to reference:

Table -> NumPlan

Field -> AlertingName

it's trickier now using just the CLI but if you look into the DB dictionary for CUCM 5 you can probably use something similar.

AFAIK the DB structure is almost the same as with CCM 4.1(3) just some minor changes

HTH

HTH

java

if this helps, please rate

www.cisco.com/go/pdi
New Member

Re: Bulk updating Alerting names in CCM5.1.2

Guy's,

Thanks for the help. As I'm still relatively new to the IPT game, I think I need to stick TAC supported stuff until I'm a bit more savvy!

I got round this by getting the new guy to do it manually (gave him some good experience with the CCM 5 Interface!!)

Thanks again

Dan

Re: Bulk updating Alerting names in CCM5.1.2

Hi Daniel,

Did you resolved your problem?

I have same problem with CCM 6.0.

Thank you,

Cristian

137
Views
4
Helpful
4
Replies
CreatePlease to create content