[cisco-voip] CCM 6.1 vs CCM 4.2.3

[Ed Leatherman]

We've had a number of freedom of information act requests for phone records
lately, I just had to deal with figuring this out last weekend. We normally
do not store CDR's longer than what they stay in the CCM database and only
use for troubleshooting.

You can use an external SFTP server, CM just dumps flat CDR files at a
configurable interval (default was 1 minute I believe). From there you can
import them into your own database, billing software, etc.

I think there is a mechanism in 5.x to do queries from the command line,
"run sql", I havent tried it. Don't know if it's still there in v6. I think
it would be hard to manipulate large results this way though.

Another option is to use CAR and do a CDR export, download the flat file and
manipulate it yourself. The only option is to download ALL records for a
given timeframe, so you would have to process them yourself after you
export. I would shy away from doing this during production hours, seemed
like the server really took a hit when I did it and asked for a month's
worth of records. ymmv.


On Thu, May 29, 2008 at 9:07 PM, Lelio Fulgenzi <lelio at uoguelph.ca> wrote:

>  Is the external server a database server or a text file dump?
>
> What about the actual callmanager database, can you do SQL querries from
> the command line?
>
>
> --------------------------------------------------------------------------------
> Lelio Fulgenzi, B.A.
> Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
> (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
>
>


-- 
Ed Leatherman
Senior Voice Engineer
West Virginia University
Telecommunications and Network Operations
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080530/53aaa054/attachment.html>