<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 href="mailto:Dennis.Heim@cdw.com">Dennis.Heim@cdw.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p><span style="COLOR: #1f497d; 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: #1f497d; FONT-SIZE: 11pt"> </span></p>
<p><span style="COLOR: #1f497d; 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: #1f497d; FONT-SIZE: 10pt">317.694.6070 Cell</span></p>
<p><span style="COLOR: #1f497d; FONT-SIZE: 11pt"><a 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 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: #1f497d"></span></p>
<p><span style="COLOR: #1f497d; FONT-SIZE: 11pt"> </span></p>
<div style="BORDER-BOTTOM: medium none; BORDER-LEFT: medium none; PADDING-BOTTOM: 0in; PADDING-LEFT: 0in; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; BORDER-RIGHT: medium none; PADDING-TOP: 3pt">
<p><b><span style="FONT-SIZE: 10pt">From:</span></b><span style="FONT-SIZE: 10pt"> <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></p></div>
<div>
<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>