<div dir="ltr"><div>The parameter below defines the max age of a record that will be preserved, if push comes to shove, and CDR manager needs to purge old files.</div><div><br></div><div><b><u>CDR / CMR Files Preservation Duration (Days)</u></b><br></div><div><div>Choose the number of days that you want to retain CDR and CMR files. The CDR Repository Manager deletes files that fall outside the preservation window.</div><div><b>Note </b>If you continuously receive the CDRMaximumDiskSpaceExceeded alarm, you either must increase the disk allocation or lower the number of preservation days.</div></div><div><br></div><div>However, the disk space allocation, and whether you're doing calls with zero duration, etc, all contribute to "how many" or "how far back" type questions.</div><div><br></div>I just checked two independent systems, and March 24th was the oldest record on both. Interesting.<div><br></div><div><div><font face="monospace">admin:run sql car select limit 1 datetimestamporigination from tbl_billing_data order by datetimestamporigination asc</font></div><div><font face="monospace">datetimestamporigination</font></div><div><font face="monospace">========================</font></div><div><font face="monospace">2017-03-24 01:19:48</font></div><div><br></div></div><br><div class="gmail_quote"><div dir="ltr">On Mon, May 22, 2017 at 9:09 AM Haas, Neal <<a href="mailto:nhaas@co.fresno.ca.us">nhaas@co.fresno.ca.us</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I don’t think you can do more than 60 days on CUCM, it just does not have the storage to do that. We use Variphy Insight. They will give you a demo for a month or two. Vary easy to setup.<br>
<br>
Thank You,<br>
<br>
Neal Haas<br>
NSE, Communications<br>
Please report Troubles to the Help Desk. <a href="tel:(559)%20600-5900" value="+15596005900" target="_blank">559-600-5900</a><br>
Telephone <a href="tel:(559)%20600-5890" value="+15596005890" target="_blank">(559) 600-5890</a><br>
<br>
-----Original Message-----<br>
From: cisco-voip [mailto:<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">cisco-voip-bounces@puck.nether.net</a>] On Behalf Of Gary Parker<br>
Sent: Monday, May 22, 2017 1:06 AM<br>
To: Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank">bmeade90@vt.edu</a>><br>
Cc: <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>; Jonatan Quezada <<a href="mailto:jonatan.quezada@chemeketa.edu" target="_blank">jonatan.quezada@chemeketa.edu</a>><br>
Subject: Re: [cisco-voip] CDR on cucm analysis reports<br>
<br>
<br>
> On 21 May 2017, at 22:34, Brian Meade <<a href="mailto:bmeade90@vt.edu" target="_blank">bmeade90@vt.edu</a>> wrote:<br>
><br>
> CAR DB only holds up to 30 days. You need a billing server to offload CDR to if you need to keep info longer than that.<br>
><br>
> On Fri, May 19, 2017 at 4:29 PM, Jonatan Quezada <<a href="mailto:jonatan.quezada@chemeketa.edu" target="_blank">jonatan.quezada@chemeketa.edu</a>> wrote:<br>
> does anyone have any insight on where to adjust how far back to report on. I get a limit when I try a report older than a month. We should be able to go back for a year? right. if this is a setting for how long to archive call details, where do i change that?<br>
<br>
If you don’t already have billing server, can’t get the budget for one or want something a bit different to the regular packages, I can highly recommend Damien Hauser’s CUCM/ELK integration tools. You it’s free (all based on open source tools) and gives you a full elasticsearch database of CDR/CMR database with a Kibana frontend and logstash ingest. There’s even a load of pre-configured reports and visualisations for you to modify for your own needs.<br>
<br>
GitHub repo here:<br>
<a href="https://github.com/damhau/cucm-cdr" rel="noreferrer" target="_blank">https://github.com/damhau/cucm-cdr</a><br>
<br>
Some more detailed installation instructions here:<br>
<a href="https://damienetwork.wordpress.com/2015/10/09/elk-setup-for-cucm-cdr/" rel="noreferrer" target="_blank">https://damienetwork.wordpress.com/2015/10/09/elk-setup-for-cucm-cdr/</a><br>
<br>
You *will* need a working knowledge of linux to get this working but the results are worth it, imho. We get a lot more useful technical information out of this than we do our Tiger call logger/billing platform.<br>
<br>
<br>
---<br>
/-Gary Parker----------------------------------f--\<br>
| Unified Communications Service Manager |<br>
n Loughborough University, IT Services |<br>
| tel:<a href="tel:+44%201509%20635635" value="+441509635635" target="_blank">+441509635635</a> <a href="mailto:sip%3Agary@lboro.ac.uk" target="_blank">sip:gary@lboro.ac.uk</a> o<br>
| <a href="http://delphium.lboro.ac.uk/pubkey.txt" rel="noreferrer" target="_blank">http://delphium.lboro.ac.uk/pubkey.txt</a> |<br>
\r----------------------------------------------d-/<br>
<br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</blockquote></div></div>