01-15-2004 08:36 AM - edited 03-13-2019 03:21 AM
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?
01-16-2004 10:23 AM
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
01-16-2004 10:23 AM
.
01-16-2004 11:07 AM
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.
01-16-2004 12:14 PM
Thanks! This is what I was missing:WHERE (tkPatternUsage = 3) !!!
Tim Moffett
01-16-2004 12:45 PM
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
01-19-2004 12:44 AM
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?
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: