Getting all route patterns

Version 1
    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/