AXL Query to get the list of IP Phone services configured on CUCM

[cdnadmin]

This document was generated from CDN thread

Created by: Ahmad Imtiaz on 09-12-2009 12:46:58 PM
I am looking Query to get the list of IP Phone services configured on CUCM.

Subject: RE: AXL Query to get the list of IP Phone services configured on CUCM
Replied by: David Staudt on 09-12-2009 04:00:45 PM
The 'telecasterservice' table contains this information, see the Data Dictionary for details:
 

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:ns="http://www.cisco.com/AXL/API/7.0">
   <soapenv:Header/>
   <soapenv:Body>
      <ns:executeSQLQuery sequence="1">
         <sql>select t.pkid,t.name,t.description,c.name from telecasterservice as t,typephoneservicecategory as c where t.tkphoneservicecategory=c.enum</sql>
      </ns:executeSQLQuery>
   </soapenv:Body>
</soapenv:Envelope>
------------------------

<SOAP-ENV:Envelope SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/" xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/">
   <SOAP-ENV:Header/>
   <SOAP-ENV:Body>
      <axl:executeSQLQueryResponse sequence="1" xmlns:axl="http://www.cisco.com/AXL/API/7.0" xmlns:xsi="http://www.cisco.com/AXL/API/7.0">
         <return>
            <row>
               <pkid>d0059763-cdcc-4be7-a2a8-bbd4aac73f63</pkid>
               <name>XML Service</name>
               <description>Missed Calls</description>
               <name>XML Service</name>
            </row>
            <row>
               <pkid>0061bdd2-26c0-46a4-98a3-48a6878edf53</pkid>
               <name>XML Service</name>
               <description>Received Calls</description>
               <name>XML Service</name>
            </row>
            <row>
               <pkid>a0eed443-c705-4232-86d4-957295dd339c</pkid>
               <name>XML Service</name>
               <description>Placed Calls</description>
               <name>XML Service</name>
            </row>
            <row>
               <pkid>27f92f3c-11ed-45f3-8400-fe06431c0bfc</pkid>
               <name>XML Service</name>
               <description>Intercom Calls</description>
               <name>XML Service</name>
            </row>
            <row>
               <pkid>4a9d384a-5beb-4449-b176-cea0e8c4307c</pkid>
               <name>XML Service</name>
               <description>Personal Directory</description>
               <name>XML Service</name>
            </row>
            <row>
               <pkid>7eca2cf1-0c8d-4df4-a807-124b18fe89a4</pkid>
               <name>XML Service</name>
               <description>Corporate Directory</description>
               <name>XML Service</name>
            </row>
            <row>
               <pkid>ca69f2e4-d088-47f8-acb2-ceea6722272e</pkid>
               <name>XML Service</name>
               <description>Voicemail</description>
               <name>XML Service</name>
            </row>
            <row>
               <pkid>4af09883-7b4e-e686-ae31-dfa4525929a4</pkid>
               <name>XML Service</name>
               <description>Extension Mobility</description>
               <name>XML Service</name>
            </row>
            <row>
               <pkid>ea4c964b-0c1d-a227-24e2-d1464816df47</pkid>
               <name>XML Service</name>
               <description>TestService description</description>
               <name>XML Service</name>
            </row>
         </return>
      </axl:executeSQLQueryResponse>
   </SOAP-ENV:Body>
</SOAP-ENV:Envelope>

Subject: RE: AXL Query to get the list of IP Phone services configured on CUCM
Replied by: Ahmad Imtiaz on 10-12-2009 06:44:41 AM
Thanks David this what I was looking for.