HomeCisco networkingCisco call managerCisco CallManager Bulk Update - Route Pattern

Cisco CallManager Bulk Update – Route Pattern

To update a large number of route patterns, some database digging is required. This works with Cisco CallManager CCM 4.0(1) sr2a.


I recently created many route patterns and needed to change some parameters. Since there is no bulk editing tool, I was forced to change these parameters one at a time or break out the SQL Query Analyzer.

Luckily, I had included a description in the route patterns in question, so the query to find them was significantly easier.

In query analyzer, I started with the following:
use CCM0300
select * from dbo.NumPlan where Description = 'Site1'

This produces a list so that you can verify the correct number of rows from the messages tab. From the grids tab, take a look at the column names and data to verify the correct rows were returned.

Once you are satisfied with the row results, I tested changing the parameters in the CallManager web interface with a specific entry to find the columns which needed updating.

use CCM0300
select * from dbo.NumPlan where Description = 'Site1' and DNOrPattern = '9.1555666XXXX'

Three columns needed changing in my case, Other cases may vary. To change the values for all desired route patterns, I used this query:
use CCM0300
update dbo.NumPlan set fkDigitDiscardInstruction = NULL, CalledPartyTransformationMask = 'XXXXXXX', PrefixDigitsOut = '9' where Description = 'Site1'

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

- Advertisment -

Most Popular

Recent Comments

Cleveland Furia on How to Clear Google Activity
Sid Wohlfarth on How to Clear Google Activity
Riley Magsayo on How to Clear Google Activity
สมัครรับเครดิตฟรี ทันที on How to improve Remote Desktop Protocol Performance
Neal Wangstad on How to Clear Google Activity
Slavcho Andov on How to install Ubuntu
Slavcho Andov on How to fix bad sectors
Sheraz Ali on How to Backup Android