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.<br>
<br>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. <br><br>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. <br>
<br>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. <br>
<br><br><div class="gmail_quote">On Thu, May 29, 2008 at 9:07 PM, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca">lelio@uoguelph.ca</a>> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff">
<div><font face="Arial" size="2">Is the external server a database server or a text
file dump?</font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">What about the actual callmanager database, can you
do SQL querries from the command line?</font></div>
<div> </div>
<div>--------------------------------------------------------------------------------<br>Lelio
Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario
N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX
(JNHN)<br>^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
<br></div><br></div>
</blockquote></div><br><br clear="all"><br>-- <br>Ed Leatherman<br>Senior Voice Engineer<br>West Virginia University<br>Telecommunications and Network Operations