[cisco-voip] Max CDR Records

[Keith Klevenski]

Yea, that sounds like a good idea.  I may consider doing something like that as it is awful nice to have the actual CDRs available if you need them rather than a 3rd party's version of them.

Keith Klevenski
IP Telephony Engineer
RigNet Inc.
1880 S. Dairy Ashford
Suite 300
Houston, TX 77077         
Office:   +1 281.674.0702
Mobile:  +1 713.677.3925
http://www.rig.net

"Extending the power of your knowledge"


-----Original Message-----
From: cisco-voip-bounces at puck.nether.net [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Robert Singleton
Sent: Monday, August 27, 2007 9:06 AM
To: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] Max CDR Records

On Fri, 2007-08-24 at 15:16 -0500, Keith Klevenski wrote:

>  Silly me, I thought I’ve been keeping CDRs for a year when actually I
> only had 6 weeks worth so I was just going to run a simple SQL query
> and give them exactly what they wanted.  Not.
> 
>  
> 
> I guess 1.5 mil is the recommended setting for a reason.  20 mil CDRs
> on box is silly I guess.  It just forces me to lean more on Infortel
> which I do not like.  K

I faced a similar problem and only recently started doing something I
should have been doing all along, archiving my CDRs on another server.

I have not as yet written a script to put them on another SQL, but what
I'm archiving is the results of a "select * from CallDetailRecord" and
"select * from CallDetailRecordDiagnostic" daily. The cron job runs at
04:00 each day and most days are about 3.5MB compressed. I started the
automatic process on Jun 1 and manually archived what was existing at
that time, so I have daily captures back to April 18.

I also found it handy to know what range of CDRs are available and wrote
a quick script that gets min(dateTimeOrigination) and
max(dateTimeOrigination) and returns them in human readable format.

Robert


_______________________________________________
cisco-voip mailing list
cisco-voip at puck.nether.net
https://puck.nether.net/mailman/listinfo/cisco-voip