cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
492
Views
0
Helpful
0
Comments
cdnadmin
Community Member
This document was generated from CDN thread

Created by: Ales Tepina on 17-04-2009 10:04:11 AM
Hi!
 
I''m interested in getting as much call routing information out of CUCM as possible.
 
I'm seeing lack of get all commands in AXL. For instance, if i want to get all route lists out of CUCM, first i do an executeSQLQuery, where i use an sql sentence: select * from routelist. But the result i get has no name or uuid parameter.
If i use getRouteList soap request i have to specify at least one parameter (name or uuid).
 
How can i solve that?
 
Having the same problem with routePattern, but i can't even seem to find the table where route patterns are listed.
 
Thank you for your response in advance!
 
Ales

Subject: RE: Getting all route patterns
Replied by: BHUVANESWARI RAJAMANICKAM on 20-04-2009 12:13:08 PM
Hi Ales,
 
I think the SQL query "select * from routelist" will contain pkid where pkid is "uuid" parameter. And the route patterns go into "numplan" table. The corresponding SQL query to list the route patterns is "select * from numplan where tkpatternusage = 5".
 
HTH.
 
Thanks and Regards,
Bhuvana
Cisco Developer Services
http://developer.cisco.com/

Subject: RE: Getting all route patterns
Replied by: Ales Tepina on 26-04-2009 07:36:40 AM
I got the route patterns names from "listRoutePlanByType" and the parameter (usage="Route").
 
Got route lists from 3 SQL queries:
select * from typeclass where name = "Route List"    -> look for "enum"
select * from typeproduct where name = "Route List    -> look for "enum"
and then the last SQL query (i'm using perl....these two are scalars where i keep my values)
select * from device where tkclass = " . $enum_typeclass . " and tkproduct = " . $enum_typeproduct 

Subject: RE: Getting all route patterns
Replied by: Arief Muslim on 21-10-2010 06:24:31 AM
Hi Bhuvana,
 
I need to get a list of route patterns where the associated device (the gateway ip the pattern is pointing to) begins with 10.9.X.X. This can be done easily from the CUCM page. Can you help me construct an SQL query for this?
 
thanks in advance for your help!
 
Regards,
Arief
 

Hi Ales,
 
The corresponding SQL query to list the route patterns is "select * from numplan where tkpatternusage = 5".
 
HTH.
 
Thanks and Regards,
Bhuvana
Cisco Developer Services
http://developer.cisco.com/
Getting Started

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:

Quick Links