[cisco-voip] SQL dips

[Kevin Dunn]

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/f39f9c30/attachment.html>