[cisco-voip] SQL dips

[Dennis Heim]

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 3rd part cdr apps out that that will do all that for you.

Dennis Heim
Network Voice Engineer
CDW  Advanced Technology Services
11711 N. Meridian Street, Suite 225
Carmel, IN  46032

317.569.4255 Office
317.569.4201 Fax
317.694.6070 Cell
dennis.heim at cdw.com<mailto:dennis.heim at cdw.com>
www.berbee.com<http://www.berbee.com/>

From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Kevin Dunn
Sent: Friday, August 21, 2009 12:43 PM
To: Cisco Voice
Subject: [cisco-voip] SQL dips

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.

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.

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)?

Is anyone else doing that?

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.

Thoughts, Comments?

Kevin
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090821/1edc16a2/attachment.html>