CDROneDemand's get_file_list function

[shikamarunara]

Hello,

     I am working on a CDR application and am wondering if someone happens to know why the get_file_list function can only pull records for a 60 minute period?  I would like to render a list of all CDR files on a single page, but I feel compelled to ask about this restriction.  Does anyone know?

[Rob Huffman]

Hi Shikamarunara,

Freezing & snowy here today ...BRRRRRRRRRR!

This may impact the 60 minute files;

Configuring CDR Enterprise Parameters

Configure these CDR parameters on the Enterprise Parameters Configuration window in the Cisco Unified CallManager Administration. To access Enterprise Parameters Configuration windows, open Cisco Unified CallManager Administration and choose System -> Enterprise Parameters.

•CDR Parameters

–CDR File Time Interval—This  parameter specifies the time interval for collecting CDR data. For  example, if this value is set to 1, each file will contain 1 minute of  CDR data (CDRs and CMRs, if enabled). The external billing server and CAR database will not receive the data in each file until the interval expires (or sometime later, depending on the CAR Loader schedule setting). Consider how quickly you want access to the CDR data when you decide what interval to set for this parameter. Setting  this parameter to 60 means that each file will contain 60 minutes worth  of data, but that data will not be available until the 60-minute period  has elapsed, and the records are written to the CAR database. The CDR files are sent to the configured billing server(s). The default value specifies 1.  The minimum value specifies 1, and the maximum value specifies 1440.  The unit of measure for this required field represents a minute.

–Cluster ID—This  parameter provides a unique identifier for the cluster. Because the  parameter gets used in CDRs, collections of CDRs from multiple clusters  can be traced to the sources.The default value specifies  StandAloneCluster. The maximum length comprises 50 characters and  provides a valid cluster ID that comprises any of the following  characters: A-Z, a-z, 0-9, . -.

•CCM Web Services Parameters

–Allowed CDRonDemand get_file Queries Per Minute—This  parameter specifies the maximum number of CDRonDemand get_file queries  that are allowed per minute for the system. For this required field the  default value specifies 10. The minimum value equals 1 and the maximum  value equals 20.

–Allowed CDRonDemand get_file_list Queries Per Minute—This  parameter specifies the maximum number of CDRonDemand get_file_list  queries that are allowed per minute for the system. For this required  field the default value specifies 20. The minimum value equals 1 and the  maximum value equals 40.

Cheers!

Rob

"Seek it out and ye shall find  " 

- OneRepublic

[shikamarunara]

Hey Rob,

     Well, I'm down here in AZ.  I'll keep you in my thoughts

     This looks like an answer to a different question.  I think there's no workaround, the

Cisco Unified Communications Manager XML Developers Guide says that I just need to use get_file_list multiple times to get files over more than one hour.  But, I must say, this is truly vexing that CDR used to be query-able directly from a database (like uccx);

In previous releases, the CDR database stored CDR records, and third-party applications could query the

database directly for the CDR records. In this release, CDRs no longer get stored in the CDR database,

but as flat files. (from 4-123)

And now I need to query flat files for the same thing.  Really backwards.