[cisco-voip] CDR on cucm analysis reports

[Anthony Holloway]

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.

*CDR / CMR Files Preservation Duration (Days)*
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.
*Note   *If you continuously receive the CDRMaximumDiskSpaceExceeded alarm,
you either must increase the disk allocation or lower the number of
preservation days.

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.

I just checked two independent systems, and March 24th was the oldest
record on both.  Interesting.

admin:run sql car select limit 1 datetimestamporigination from
tbl_billing_data order by datetimestamporigination asc
datetimestamporigination
========================
2017-03-24 01:19:48


On Mon, May 22, 2017 at 9:09 AM Haas, Neal <nhaas at co.fresno.ca.us> wrote:

> 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.
>
> Thank You,
>
> Neal Haas
> NSE, Communications
> Please report Troubles to the Help Desk. 559-600-5900 <(559)%20600-5900>
> Telephone (559) 600-5890
>
> -----Original Message-----
> From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of
> Gary Parker
> Sent: Monday, May 22, 2017 1:06 AM
> To: Brian Meade <bmeade90 at vt.edu>
> Cc: cisco-voip at puck.nether.net; Jonatan Quezada <
> jonatan.quezada at chemeketa.edu>
> Subject: Re: [cisco-voip] CDR on cucm analysis reports
>
>
> > On 21 May 2017, at 22:34, Brian Meade <bmeade90 at vt.edu> wrote:
> >
> > 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.
> >
> > On Fri, May 19, 2017 at 4:29 PM, Jonatan Quezada <
> jonatan.quezada at chemeketa.edu> wrote:
> > 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?
>
> 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.
>
> GitHub repo here:
> https://github.com/damhau/cucm-cdr
>
> Some more detailed installation instructions here:
> https://damienetwork.wordpress.com/2015/10/09/elk-setup-for-cucm-cdr/
>
> 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.
>
>
> ---
> /-Gary Parker----------------------------------f--\
> |     Unified Communications Service Manager      |
> n      Loughborough University, IT Services       |
> |     tel:+441509635635 <+44%201509%20635635> sip:gary at lboro.ac.uk      o
> |     http://delphium.lboro.ac.uk/pubkey.txt      |
> \r----------------------------------------------d-/
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20170522/510534a5/attachment.html>