Add speed dial on existing phones via BAT

Unanswered Question
Dec 3rd, 2007

we are running on CCM 5.1.(2) with 7941 phones deployed. User is requesting to add a speed dial with number thoughout all 7941 Phones. Can i use BAT to work this out? or any effective way to proceed this?

Thank you

I have this problem too.
0 votes
  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
allan.thomas Tue, 12/04/2007 - 01:21

Unfortunately I'm not aware of any other alternative for updating the abbrev. speed-dials for existing phones other than through BAT.

The only problem with BAT in this particular scenario is that it is not specifically possible to use the update phones option in ordrer to update only the speed-dials.

Speed-dials can only being added when you insert with the template.

Regards

Allan.

leechehcheng Tue, 12/04/2007 - 01:28

Allan,

Back to CCM 4.X, we can always use SQL query analyzer to make some changes on the speed dial table. Do you have any idea on doing the similar thing on CCM5.X?

allan.thomas Tue, 12/04/2007 - 01:38

I can sympathise with us on this one, as there has many occasion where I would have done the same. :-(

Unfortunately, I have not come across any alternatives, or other threads on NetPro which discusses being able to do this.

Regards

Allan.

sr2290723 Wed, 12/12/2007 - 18:42

Hi Lee,

I'm interested in the way you update the speed dial using SQL Query Analyzer to change the speed dial table. Can you explain me how to do it ? I have the same request where I should update speed dials on specific location.

Thanks, Lee.

Wiyandi

leechehcheng Wed, 12/12/2007 - 18:47

Wiyandi,

What CCM version you are using?

I cannot remember exactly, because our CCM version had been updated from 4.2 to 5.1. You just need a bit knowledge on SQL query, there is a speed dial table can be found in SQL enterprise manager.

Hope it help.

sr2290723 Wed, 12/12/2007 - 22:55

I'm using CCM 4.1(3)SR5B. In the speed dial table, I find the fields : pkid, fkdevice, speeddialindex, speeddialnumber, label, msrepl_tran_version. From what I see, this table describes the speed dials for each IP phone. Am I right ? I have basic knowledge of SQL queries, but it's better to give me a sample query to make me understand :D. Thanks, Lee.

Wiyandi

Actions

This Discussion