Cisco Support Community
Showing results for 
Search instead for 
Did you mean: 

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Using SQL to update Translation Patterns in CUCM 9.1


I have approximately 400 translation patterns that I have exported from one CUCM 9.1 system that I want to import into another CUCM 9.1 system as this will save me lots of work.

I have done this and the import was successful but when I look at the Translation Patterns in CUCM admin the value for

Discard Digits under Called Party Transformations is shown as < None > where it should be PreDot.

Oddly when I export the Translation Patterns from the CUCM cluster to which I have just imported them the value shown in the csv file is PreDot

I was wondering whether it would be possible to change the value for Discard Digits using SQL. Despite reading Bill Bell's helpful blog series I am struggling to work out how to do this.

The basic operation I want to do is described below:

Update Discard Digits to PreDot for all Translation Patterns that start with 90.

Can anyone help me with this?