[cisco-voip] Max CDR Records

[Keith Klevenski]

Actually we are using Infortel.  Can't say I'm a big fan of it, but I
suppose it works.  Actually I don't like it at all.  Actually I don't
like dealing with phone bills at all.  Actually I hate dealing with
phone bills.  

 

Anyway... we upgraded back in March to a version that has a redirected
number report.  One problem is I can't go any further back than March.
I've been asked for a report of calls to the NOC that when to voicemail
starting in December in Excel format (Infortel will only give you a PDF,
HTML, or RTF for this particular report.. LAME).  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

 

 

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 <http://www.rig.net/> 

 

"Extending the power of your knowledge"

 

From: Jason Aarons (US) [mailto:jason.aarons at us.didata.com] 
Sent: Friday, August 24, 2007 2:33 PM
To: Keith Klevenski; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] Max CDR Records

 

I would look at a third-party to archive your CDRs, ever try to upgrade
CallManager versions with 13 mil records in the db ? Could take a day or
more just to run the upgrade..

 

InforTel for Windows has some good features, allows offbox archiving of
cdrs -jason

 

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Keith Klevenski
Sent: Friday, August 24, 2007 3:18 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Max CDR Records

 

Is there any problem with changing the max CDR records service parameter
to a significantly higher number?  1.5 mil records is about 6 weeks for
us which really isn't enough.  I was wondering why the records only went
back 6 weeks since I have automatic purging set to 365 days, but totally
forgot about the max CDR records parameter.  :P  I'd like to keep a year
if possible which would be about 13 mil records.  The call volume is
only going up so I was thinking about setting it to 15 mil or even 20
and let the automatic purge handle anything over 365 days.  

 

Other than the size of the backup and disk space, is there any reason
not to set this so much higher than the 1.5 mil 'recommended' setting?

 

Thanks.

 

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 <http://www.rig.net/> 

 

"Extending the power of your knowledge"

 

________________________________

Disclaimer: This e-mail communication and any attachments may contain
confidential and privileged information and is for use by the designated
addressee(s) named above only. If you are not the intended addressee,
you are hereby notified that you have received this communication in
error and that any use or reproduction of this email or its contents is
strictly prohibited and may be unlawful. If you have received this
communication in error, please notify us immediately by replying to this
message and deleting it from your computer. Thank you. 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: https://puck.nether.net/pipermail/cisco-voip/attachments/20070824/c61cf86f/attachment-0001.html