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