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

Any way to extract translation pattern info?

I am looking for a way to extract translation patterns without having to look at each one individually. Does anyone know of a way? The dialplan report only shows the pattern to be translated, not the number to translate to.

Maybe with the SQL query analyzer?

6 REPLIES
New Member

Re: Any way to extract translation pattern info?

I would like this info also. I am sure that there would be a way to do it with a SQL query, but I am not very well versed in SQL. Please send me anyt info that you think might help. We are running CCM 3.2(2c) es 79

New Member

Re: Any way to extract translation pattern info?

.

New Member

Re: Any way to extract translation pattern info?

while you're not supposed to go digging in the SQL database and I am assuming you are trying this in a non-production environment and am in no way responsible for adverse results this will probably work for you

SELECT *

FROM NumPlan

WHERE (tkPatternUsage = 3)

But I would double check the value of tkPatternUsage on your version this is from 3.3

More appropriately (and supported) would be to use the AXL SOAP ListRoutePlanByType method.

New Member

Re: Any way to extract translation pattern info?

Thanks! This is what I was missing:WHERE (tkPatternUsage = 3) !!!

Tim Moffett

New Member

Re: Any way to extract translation pattern info?

yeah that is what defines the type of pattern in 3.3 they are

0 CallPark

1 Conference

2 Device

3 Translation

4 Call Pick Up Group

5 Route

6 Message Waiting

New Member

Re: Any way to extract translation pattern info?

I am interested in extracting translation patterns, manipulation the information and importing the changes. Can I use the SQL Import/Export feature to do this?

221
Views
0
Helpful
6
Replies