Filtering route patterns

Version 1
    This document was generated from CDN thread

    Created by: Arief Muslim on 27-10-2010 03:21:34 AM
    Hi,
     
    I understand that SQL query ¿select * from numplan where tkpatternusage = 5¿ will give me a complete list of route patterns.
     
    I will need to filter these route patterns to show only the patterns where the ¿¿associated device begins with 10.9.¿ How do I construct an sql query to achieve this? The result should be the same as the one done from the CUCM page, see attached picture.
     
    Thanks in advance for any help!
     
    cheers,
    Arief

    Subject: RE: Filtering route patterns
    Replied by: Arief Muslim on 27-10-2010 11:43:01 PM
    Thanks David! I will give it a try.
     
    cheers,
    Arief
     
     
    Something like this should work:
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.0">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:executeSQLQuery sequence="1">
             <sql>select numplan.* from numplan,device,devicenumplanmap where numplan.tkpatternusage=5 and devicenumplanmap.fkdevice=device.pkid and devicenumplanmap.fknumplan=numplan.pkid and device.name like '10.9%'</sql>
          </ns:executeSQLQuery>
       </soapenv:Body>
    </soapenv:Envelope>
     
     


    Subject: RE: Filtering route patterns
    Replied by: David Staudt on 27-10-2010 11:09:05 PM
     
    Something like this should work:
     
     
     
    <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/8.0">
       <soapenv:Header/>
       <soapenv:Body>
          <ns:executeSQLQuery sequence="1">
             <sql>select numplan.* from numplan,device,devicenumplanmap where numplan.tkpatternusage=5 and devicenumplanmap.fkdevice=device.pkid and devicenumplanmap.fknumplan=numplan.pkid and device.name like '10.9%'</sql>
          </ns:executeSQLQuery>
       </soapenv:Body>
    </soapenv:Envelope>