[cisco-voip] SQL dips

[Kevin Dunn]

Okay I think I have a firm grasp on what these guys are asking for:

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.

1.  If I remove the SQL database from CUCM 7.0 what will that break?
2.  Can I add a login to the CUCM7.0 just for running queries (read only)?

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.

Kevin

On Fri, Aug 21, 2009 at 12:08 PM, Dennis Heim <Dennis.Heim at cdw.com> wrote:

>  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
> 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/20090826/233a4f69/attachment.html>