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

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.

New Member

export translation patterns from CUCM 5x

Hi experts

Is there any way to export a list of translation patterns from CUCM 5x.

Sent from Cisco Technical Support iPad App

  • IP Telephony
1 ACCEPTED SOLUTION

Accepted Solutions
Super Bronze

Re: export translation patterns from CUCM 5x

Good stuff...

Please remember to rate replies and mark 'answered' if appropriate!

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
4 REPLIES
Hall of Fame Super Silver

Re: export translation patterns from CUCM 5x

sorry, but import/export feature was not added until CUCM 6.0.

Chris

Sent from Cisco Technical Support iPhone App

Super Bronze

export translation patterns from CUCM 5x

Unless you are feeling adventurous:

admin:run sql select dnorpattern,calledpartytransformationmask  from numplan where tkpatternusage = 3

dnorpattern calledpartytransformationmask

=========== =============================

!

888         304500

0           223322

!

*6333       9812006

9999

222254

22200[5-8]  0

!

Take a look at the DB definition guide to wee what other fields you might like. You can log this to text then load it with Excel or whatever.

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
New Member

Re: export translation patterns from CUCM 5x

Thanks Aaron

The SQL queries work wonderfully

Sent from Cisco Technical Support iPad App

Sent from Cisco Technical Support iPad App

Super Bronze

Re: export translation patterns from CUCM 5x

Good stuff...

Please remember to rate replies and mark 'answered' if appropriate!

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
624
Views
10
Helpful
4
Replies
This widget could not be displayed.