<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[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]-->
</head>
<body lang=NO-BOK link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='color:#1F497D'>Hey<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks for your reply. </span><span
lang=EN-US style='color:#1F497D'>It pointed our developer in the right
direction </span><span lang=EN-US style='font-family:Wingdings;color:#1F497D'>J</span><span
lang=EN-US style='color:#1F497D'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>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. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Does anyone know the
table name for directory numbers ?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Does anyone have a list
of nice to know tablenames ?<br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Best regard<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Tor-Ivar Kristoffersen<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>Fra:</span></b><span
style='font-size:10.0pt;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<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Hi,</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;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:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'> <o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:navy'>Regards</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
</div>
<div>
<p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p> </o:p></span></p>
</div>
<div class=MsoNormal align=center style='text-align:center'><span lang=EN-US
style='font-size:12.0pt;font-family:"Times New Roman","serif"'>
<hr size=2 width="100%" align=center>
</span></div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span lang=EN-US
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
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
lang=EN-US style='font-size:12.0pt;font-family:"Times New Roman","serif"'><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Hi<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></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.<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></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. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>So the question is. <o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></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 ? ) ?<o:p></o:p></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 ?<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Also all other tips and tricks are welcome </span><span
lang=EN-US style='font-family:Wingdings'>J</span><span lang=EN-US><o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>We are running CUCM 6.3<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Best regards<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Tor-Ivar Kristoffersen<o:p></o:p></span></p>
<p class=MsoNormal><span lang=EN-US>Lufttransport AS<o:p></o:p></span></p>
</div>
</body>
</html>