<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
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 class="moz-txt-link-freetext" 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 class="moz-txt-link-rfc2396E" href="mailto:cheesevoice@gmail.com"><cheesevoice@gmail.com></a> wrote:<br>
<blockquote
cite="mid:84b74aec0908260616k2850eaaaud4310441df04a879@mail.gmail.com"
type="cite">
<div>Okay I think I have a firm grasp on what these guys are asking
for:</div>
<div> </div>
<div>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. </div>
<div> </div>
<div>1. If I remove the SQL database from CUCM 7.0 what will that
break?</div>
<div>2. Can I add a login to the CUCM7.0 just for running queries
(read only)?</div>
<div> </div>
<div>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.</div>
<div> </div>
<div>Kevin<br>
<br>
</div>
<div class="gmail_quote">On Fri, Aug 21, 2009 at 12:08 PM, Dennis
Heim <span dir="ltr"><<a moz-do-not-send="true"
href="mailto:Dennis.Heim@cdw.com">Dennis.Heim@cdw.com</a>></span>
wrote:<br>
<blockquote
style="border-left: 1px solid rgb(204, 204, 204); margin: 0px 0px 0px 0.8ex; padding-left: 1ex;"
class="gmail_quote">
<div vlink="purple" link="blue" lang="EN-US">
<div>
<p><span style="color: rgb(31, 73, 125); font-size: 11pt;">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></p>
<p><span style="color: rgb(31, 73, 125); font-size: 11pt;"> </span></p>
<p><span style="color: rgb(31, 73, 125); font-size: 10pt;">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="color: black; font-size: 10pt;">317.569.4201 Fax<br>
</span><span style="color: rgb(31, 73, 125); font-size: 10pt;">317.694.6070
Cell</span></p>
<p><span style="color: rgb(31, 73, 125); font-size: 11pt;"><a
moz-do-not-send="true" title="mailto:dennis.heim@berbee.com"
href="mailto:dennis.heim@cdw.com" target="_blank"><span
style="color: blue;">dennis.heim@cdw.com</span></a><br>
<a moz-do-not-send="true" title="http://www.berbee.com/"
href="http://www.berbee.com/" target="_blank"><span
style="color: blue;">www.berbee.com</span></a></span><span
style="color: rgb(31, 73, 125);"></span></p>
<p><span style="color: rgb(31, 73, 125); font-size: 11pt;"> </span></p>
<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 0in 0in;">
<p><b><span style="font-size: 10pt;">From:</span></b><span
style="font-size: 10pt;"> <a moz-do-not-send="true"
href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>
[mailto:<a moz-do-not-send="true"
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></p>
</div>
<div>
<div class="h5">
<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.</p>
</div>
<div>
<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.</p>
</div>
<div>
<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)?</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>Is anyone else doing that?</p>
</div>
<div>
<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. </p>
</div>
<div>
<p> </p>
</div>
<div>
<p>Thoughts, Comments?</p>
</div>
<div>
<p> </p>
</div>
<div>
<p>Kevin</p>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
</pre>
</blockquote>
<br>
</body>
</html>