<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Verdana; font-size: 10pt; color: #000000'>Your looking for the SOAP/AXL interface. If you do a search on this on CCO and include "developer" you'll eventually get to the section that you can download the index of SOAP commands.<br><br>You should also look into the CUAE product which gives you access to more and delivers it in a GUI.<br><br>---<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>"Bad grammar makes me [sic]" - Tshirt<br><br><br>----- Original Message -----<br>From: "Tor-Ivar Kristoffersen" <tik@lufttransport.no><br>To: cisco-voip@puck.nether.net<br>Sent: Monday, May 18, 2009 9:06:13 AM GMT -05:00 US/Canada Eastern<br>Subject: Re: [cisco-voip] Developer - SQL help - Call forwaring<br><br>
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EpostStil17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EpostStil19
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page Section1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
<div class="Section1">
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Hey</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Thanks for your reply. </span><span style="color: rgb(31, 73, 125);" lang="EN-US">It pointed our developer in the right
direction </span><span style="font-family: Wingdings; color: rgb(31, 73, 125);" lang="EN-US">J</span><span style="color: rgb(31, 73, 125);" lang="EN-US"></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);" lang="EN-US"> </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);" lang="EN-US">We have been trying
to get the data that we are looking for out of the database, but we cannot seem
to find the Directory Numbers. </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);" lang="EN-US">Does anyone know the
table name for directory numbers ?</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);" lang="EN-US">Does anyone have a list
of nice to know tablenames ?<br>
<br>
</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Best regard</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">Tor-Ivar Kristoffersen</span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"> </span></p>
<div>
<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0cm 0cm;">
<p class="MsoNormal"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";">Fra:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";"> Azeer Mohinder
[mailto:cucm@gawab.com] <br>
<b>Sendt:</b> 18. mai 2009 13:10<br>
<b>Til:</b> Tor-Ivar Kristoffersen<br>
<b>Emne:</b> RE: [cisco-voip] Developer - SQL help - Call forwaring</span></p>
</div>
</div>
<p class="MsoNormal"> </p>
<div>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Hi,</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">I can only help with the SQL part here. I am not sure whether what
you want to do is actually doable. But I can tell you this, there is no direct
way to connect to CUCM database remotely. The proper way
would be running SQL statements using the (run sql) CLI command. An
alternative would be using<strong><span style="font-family: "Arial","sans-serif";">
Cisco CallManager AXL SQL Toolkit </span></strong>which is actually a
plug-in you can download from your CUCM server. You can also use AXL API
and query and update your CUCM database using <strong><span style="font-family: "Arial","sans-serif";">executeSQLQuery</span></strong>
and <strong><span style="font-family: "Arial","sans-serif";">executeSQLUpdate</span></strong>.</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size: 10pt; font-family: "Arial","sans-serif"; color: navy;">Regards</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";"></span></p>
</div>
<div>
<p class="MsoNormal"><span style="font-size: 12pt; font-family: "Times New Roman","serif";"> </span></p>
</div>
<div class="MsoNormal" style="text-align: center;" align="center"><span style="font-size: 12pt; font-family: "Times New Roman","serif";" lang="EN-US">
<hr size="2" width="100%" align="center">
</span></div>
<p class="MsoNormal" style="margin-bottom: 12pt;"><b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";" lang="EN-US">From:</span></b><span style="font-size: 10pt; font-family: "Tahoma","sans-serif";" lang="EN-US">
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On
Behalf Of </b>Tor-Ivar Kristoffersen<br>
<b>Sent:</b> Monday, May 18, 2009 9:12 AM<br>
<b>To:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> [cisco-voip] Developer - SQL help - Call forwaring</span><span style="font-size: 12pt; font-family: "Times New Roman","serif";" lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US">Hi</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">We have a developer here. And we would like
for him to integrate a call forwarding function in another web site.</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">The reason for it is we have lots of
numbers that are forwarded to the person on after hours duty. And we have
synced our AD with the call manager so users can login to the call manager to
change these settings. But we would like to be able to do this easier
from another web site where users have to log inn anyways to do other tasks. </span></p>
<p class="MsoNormal"><span lang="EN-US">So the question is. </span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Where can we find out how to connect via
SQL to the call manager (is that the preferred way ? ) ?</span></p>
<p class="MsoNormal"><span lang="EN-US">And where can we find some sort of
definition of the sql tables so we know what to change ?</span></p>
<p class="MsoNormal"><span lang="EN-US">Also all other tips and tricks are welcome </span><span style="font-family: Wingdings;" lang="EN-US">J</span><span lang="EN-US"></span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">We are running CUCM 6.3</span></p>
<p class="MsoNormal"><span lang="EN-US"> </span></p>
<p class="MsoNormal"><span lang="EN-US">Best regards</span></p>
<p class="MsoNormal"><span lang="EN-US">Tor-Ivar Kristoffersen</span></p>
<p class="MsoNormal"><span lang="EN-US">Lufttransport AS</span></p>
</div>
<br>_______________________________________________
cisco-voip mailing list
cisco-voip@puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip
</div></body></html>