<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:"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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
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;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";
color:black;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
span.EmailStyle20
{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:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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 bgcolor=white lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>Flat files is really the only way to go with appliance model.
Make sure you use a sftp server not ftp. I have run into issues related to ftp.
Do not use CoreFTP, after the trial ends it only allows 1-2 logins which slows
down the export to the SFTP server which will delay the records being exported
by several days. Then you would need to parse the flat files and put them in a
db. <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Dennis
Heim<br>
Network Voice Engineer<br>
CDW Advanced Technology Services<br>
11711 N. Meridian Street, Suite 225<br>
Carmel, IN 46032<br>
<br>
317.569.4255 Office<br>
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>317.569.4201
Fax<br>
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>317.694.6070 Cell<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><a
href="mailto:dennis.heim@cdw.com" title="mailto:dennis.heim@berbee.com">dennis.heim@cdw.com</a><br>
<a href="http://www.berbee.com/" title="http://www.berbee.com/">www.berbee.com</a></span><span
style='color:#1F497D'><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif";
color:windowtext'>From:</span></b><span style='font-size:10.0pt;font-family:
"Tahoma","sans-serif";color:windowtext'> Wes Sisk [mailto:wsisk@cisco.com] <br>
<b>Sent:</b> Wednesday, August 26, 2009 10:05 AM<br>
<b>To:</b> Kevin Dunn<br>
<b>Cc:</b> Dennis Heim; Cisco Voice<br>
<b>Subject:</b> Re: [cisco-voip] SQL dips<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi Kevin,<br>
<br>
I think you are missing the core point - the appliance is sealed in an effort
to prevent this. Measures are in place specifically to prevent outside
dips due to potential performance impacts.<br>
<br>
If you want access to the data the best approach is to send flat files to SFTP
server and import those into your own database. On the separate server
you can trend, report, update, delete, and modify to your heart's content
without impacting call processing. <br>
<br>
In my experience I get significantly improved cdr query performance from even a
default instance of mysql than with CM's instance of informix.<br>
<br>
To your specific questions:<br>
1. you will not be able to 'remove' the SQL database from CM7.0. it is a
sealed appliance. you do not get access to management tools as you did with
CM4.x<br>
2. you can run queries via CLI and via AXL. CLI is limited in what it
will do - characters such as '&' are blocked and there is no ability to
output to a file. AXL is also limited and bounded - queries above a
certain size will be aborted due to impact on Informix and Tomcat. Those
services are required for real time activities such as call routing, MWI, and
extension mobility login.<br>
<br>
You will not be 'moving' the database. Please have a look at the CDR
offload process:<br>
<a
href="http://www.cisco.com/en/US/customer/docs/voice_ip_comm/cucm/service/7_1_2/admin/sacdrm.html">http://www.cisco.com/en/US/customer/docs/voice_ip_comm/cucm/service/7_1_2/admin/sacdrm.html</a><br>
<br>
when flat files are generated they are copied to your external SFTP
server. At that point you take the files and load them into your
database. This is independent of any other processing that happens on CM.<br>
<br>
Regards,<br>
Wes<br>
<br>
<br>
<br>
On Wednesday, August 26, 2009 9:16:29 AM , Kevin Dunn <a
href="mailto:cheesevoice@gmail.com"><cheesevoice@gmail.com></a> wrote:<br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal>Okay I think I have a firm grasp on what these guys are
asking for:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>They don't want a flat file, but rather the actual SQL
Database, in CCM 4.1 they exported teh CDR to their SQL server and performed
the queries from there. <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>1. If I remove the SQL database from CUCM 7.0 what
will that break?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>2. Can I add a login to the CUCM7.0 just for running
queries (read only)?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>I think it is going to be easier to train the db guys how to
log into CUCM and run their queries than it will be to move the data. I
am afraid of what will break if the database is moved.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal> <o:p></o:p></p>
</div>
<div>
<p class=MsoNormal style='margin-bottom:12.0pt'>Kevin<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>On Fri, Aug 21, 2009 at 12:08 PM, Dennis Heim <<a
href="mailto:Dennis.Heim@cdw.com">Dennis.Heim@cdw.com</a>> wrote:<o:p></o:p></p>
<div>
<div>
<p><span style='font-size:11.0pt;color:#1F497D'>With the appliance model you
would need to setup a CDR/billing server via sftp (have had problems in the
past with ftp). It will push flat files to this server. Then you would need to
put those into a db. Then you would have your CDR source in an sql db. There
are 3<sup>rd</sup> part cdr apps out that that will do all that for you.</span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<p><span style='font-size:10.0pt;color:#1F497D'>Dennis Heim<br>
Network Voice Engineer<br>
CDW Advanced Technology Services<br>
11711 N. Meridian Street, Suite 225<br>
Carmel, IN 46032<br>
<br>
317.569.4255 Office<br>
</span><span style='font-size:10.0pt'>317.569.4201 Fax<br>
</span><span style='font-size:10.0pt;color:#1F497D'>317.694.6070 Cell</span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'><a
href="mailto:dennis.heim@cdw.com" target="_blank"
title="mailto:dennis.heim@berbee.com">dennis.heim@cdw.com</a><br>
<a href="http://www.berbee.com/" target="_blank" title="http://www.berbee.com/">www.berbee.com</a></span><o:p></o:p></p>
<p><span style='font-size:11.0pt;color:#1F497D'> </span><o:p></o:p></p>
<div style='border:none;border-top:solid windowtext 1.0pt;padding:3.0pt 0in 0in 0in;
border-color:-moz-use-text-color -moz-use-text-color'>
<p><b><span style='font-size:10.0pt'>From:</span></b><span style='font-size:
10.0pt'> <a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>
[mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>]
<b>On Behalf Of </b>Kevin Dunn<br>
<b>Sent:</b> Friday, August 21, 2009 12:43 PM<br>
<b>To:</b> Cisco Voice<br>
<b>Subject:</b> [cisco-voip] SQL dips</span><o:p></o:p></p>
</div>
<div>
<div>
<p> <o:p></o:p></p>
<div>
<p>In CCM 4.1 we pulled the CDR and moved it to an external SQL server, so my
boss and other directors could quesry 911 calls and International calls by
department, while not actually manipulating the CCM server.<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Now that we have upgraded to CUCM 7.0.2 I notice there are run sql commands
and enduser is actually a table in the SQL database now, not just stored in
directory.<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>My question: How difficult is it to copy the CDR instead of moving
it? I would like to push the CDR/CAR to the SQL server like before but
keep the original copy on the CUCM Publisher. Can I do that (if so how)?<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Is anyone else doing that?<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>The reason is my director is "an SQL guy" who doesn't like the
canned reports from Cisco, he wants his own queries. So my thought is if
there are ample [run sql SELECT whatever from Whatever] commands he needs we
may not need to MOVE the CDR and Car, rather he can learn to get the
information from teh new CUCM server without destroying it. <o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Thoughts, Comments?<o:p></o:p></p>
</div>
<div>
<p> <o:p></o:p></p>
</div>
<div>
<p>Kevin<o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
<pre><o:p> </o:p></pre><pre style='text-align:center'>
<hr size=4 width="90%" align=center>
</pre><pre><o:p> </o:p></pre><pre>_______________________________________________<o:p></o:p></pre><pre>cisco-voip mailing list<o:p></o:p></pre><pre><a
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><o:p></o:p></pre><pre><a
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><o:p></o:p></pre><pre> <o:p></o:p></pre>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>