ExecuteSQLUpdate/ExecuteSQLQuery

Version 1
    This document was generated from CDN thread

    Created by: Andres Avila on 29-06-2011 01:37:14 PM
    Hi guys,
     
    I'm trying to get some updates done on the "facinfo" table of the call manager, i'm working with C#. Using RisPort i was able to select devices or the FAC's but i cannot update the "facinfo" table D: if anyone has some pointers or maybe an example of the SOAP request i would really appreciate it. If any additional info is needed please tell me, by the way, when i try to update the table using RisPort with ExecuteSQLInputData i get error 500. Any links to documentation, examples or articles are welcome...its kind of hard to find info =/
     
    EDIT: I managed to find a solution with this guide
     
    http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/devguide/6_0_1/cucm_devguide.html
     
    Just in case any other newbies need to find the info quick hehe

    Subject: RE: ExecuteSQLUpdate/ExecuteSQLQuery
    Replied by: Wes Schochet on 05-07-2011 12:51:00 PM
    My SQL queries look like this:

    <SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <SOAP-ENV:Body>
    <axl:executeSQLQuery xmlns:axl="http://www.cisco.com/AXL/1.0" xsi:schemaLocation="http://www.cisco.com/AXL/1.0">
    <sql>select pkid from device where name='SEP00233341D33B'</sql>
    </axl:executeSQLQuery>
    </SOAP-ENV:Body>
    </SOAP-ENV:Envelope>

    and work well on  CUCM 6.1.4.