cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
112
Views
0
Helpful
0
Comments
cdnadmin
Community Member
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>
 
 
 
 
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