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
    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">
    <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>

    and work well on  CUCM 6.1.4.