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

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