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?
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide