Bulk updating Alerting names in CCM5.1.2

Unanswered Question
Jan 22nd, 2008


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!


I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 4 (1 ratings)
smahbub Mon, 01/28/2008 - 11:30

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

Jaime Valencia Mon, 01/28/2008 - 17:34

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


dselfridge Tue, 01/29/2008 - 03:07


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



This Discussion