<div>Thank you to everyone for the assistance, you are right, I am a CCM 4.1.3 guy and didn't really understand the application model. I am reading the links from Ryan and Wes now, we shoudl be able to find something here we can use.</div>
<div> </div>
<div>Thanks again</div>
<div> </div>
<div>Kevin<br><br></div>
<div class="gmail_quote">On Wed, Aug 26, 2009 at 10:07 AM, Adam Frankel <span dir="ltr"><<a href="mailto:afrankel@cisco.com">afrankel@cisco.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">Another option is to manually use the CDR-> Export CDR/CMR option which can export all the records into a single dump file.<br>
<br>Adam
<div class="im"><br><br>-----Original Message-----<br>From: Dennis Heim <<a href="mailto:Dennis.Heim@cdw.com" target="_blank">Dennis.Heim@cdw.com</a>><br>Sent: Wed, Aug 26, 2009 10:34:07 Am To: Wes Sisk <<a href="mailto:wsisk@cisco.com" target="_blank">wsisk@cisco.com</a>>, Kevin Dunn <<a href="mailto:cheesevoice@gmail.com" target="_blank">cheesevoice@gmail.com</a>><br>
CC: Cisco Voice <<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><br>Subject: Re: [cisco-voip] SQL dips<br></div>
<div class="im">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.<br>
<br><br><br>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>317.569.4201 Fax<br>317.694.6070 Cell<br><br>
</div><a href="mailto:dennis.heim@cdw.com" target="_blank">dennis.heim@cdw.com</a> <mailto:<a href="mailto:dennis.heim@cdw.com" target="_blank">dennis.heim@cdw.com</a>><br><a href="http://www.berbee.com/" target="_blank">www.berbee.com</a> <<a href="http://www.berbee.com/" target="_blank">http://www.berbee.com/</a>>
<div class="im"><br><br><br><br>*From:* Wes Sisk [mailto:<a href="mailto:wsisk@cisco.com" target="_blank">wsisk@cisco.com</a>]<br>*Sent:* Wednesday, August 26, 2009 10:05 AM<br>*To:* Kevin Dunn<br>*Cc:* Dennis Heim; Cisco Voice<br>
*Subject:* Re: [cisco-voip] SQL dips<br><br><br><br>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>
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.<br>
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" target="_blank">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></div>
<div class="im">On Wednesday, August 26, 2009 9:16:29 AM , Kevin Dunn <<a href="mailto:cheesevoice@gmail.com" target="_blank">cheesevoice@gmail.com</a>> <mailto:<a href="mailto:cheesevoice@gmail.com" target="_blank">cheesevoice@gmail.com</a>> wrote:<br>
<br>Okay I think I have a firm grasp on what these guys are asking for:<br><br><br><br>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.<br>
<br><br>1. If I remove the SQL database from CUCM 7.0 what will that break?<br><br>2. Can I add a login to the CUCM7.0 just for running queries (read only)?<br><br><br><br>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.<br>
<br><br><br>Kevin<br><br></div>On Fri, Aug 21, 2009 at 12:08 PM, Dennis Heim <<a href="mailto:Dennis.Heim@cdw.com" target="_blank">Dennis.Heim@cdw.com</a> <mailto:<a href="mailto:Dennis.Heim@cdw.com" target="_blank">Dennis.Heim@cdw.com</a>>> wrote:<br>
<br>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^rd part cdr apps out that that will do all that for you.
<div class="im"><br><br><br><br>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>317.569.4201 Fax<br>317.694.6070 Cell<br>
<br></div><a href="mailto:dennis.heim@cdw.com" target="_blank">dennis.heim@cdw.com</a> <mailto:<a href="mailto:dennis.heim@cdw.com" target="_blank">dennis.heim@cdw.com</a>><br><a href="http://www.berbee.com/" target="_blank">www.berbee.com</a> <<a href="http://www.berbee.com/" target="_blank">http://www.berbee.com/</a>><br>
<br><br><br>*From:* <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>> [mailto:<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>>] *On Behalf Of *Kevin Dunn
<div class="im"><br>*Sent:* Friday, August 21, 2009 12:43 PM<br>*To:* Cisco Voice<br>*Subject:* [cisco-voip] SQL dips<br><br><br><br>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.<br>
<br><br><br>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.<br><br><br><br>My question: How difficult is it to copy the CDR instead of moving it?<br>
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)?<br><br><br><br>Is anyone else doing that?<br><br><br><br>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.<br>
<br><br>Thoughts, Comments?<br><br><br><br>Kevin<br><br><br><br><br><br><br>------------------------------------------------------------------------<br><br><br><br><br>_______________________________________________<br><br>
cisco-voip mailing list<br><br></div><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a> <mailto:<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>>
<div class="im"><br><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br><br><br><br><br><br></div>------------------------------------------------------------------------
<div>
<div></div>
<div class="h5"><br><br>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></div></div></blockquote></div><br>