Cisco CallManager Bulk Update – Route Pattern
This works with Cisco CallManager CCM 4.0(1) sr2a.
To update a large number of route patterns, some database digging is required.
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:
select * from dbo.NumPlan where Description = 'Site1'
This produces a list, so 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 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.
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:
update dbo.NumPlan set fkDigitDiscardInstruction = NULL, CalledPartyTransformationMask = 'XXXXXXX', PrefixDigitsOut = '9' where Description = 'Site1'
Follow the reactions below and share your own thoughts.