Configuring Cisco CDR Reconciliation
- Balint Kuhar (Unlicensed)
- Peter Krasznai
For an overview of the CDR Reconciliation feature, refer to the CDR reconciliation article.
Configuration steps
Follow the steps below to configure CDR reconciliation:
Step 1 - Follow the instructions in the Cisco-side configuration section down below
Step 2 - Enable the Verba Import Service on one of your Verba servers. We recommend running the service on Verba servers with the Media Repository role
Step 3 - In the Verba web interface, navigate to Data > Import Sources
Step 4 - Click on the Add New Import Source button at the top-right corner of the page
Step 5 - Define the name of the Import Source. This name identifies this source in the system
Step 6 - For the type, select Cisco IPT CDR
Step 7 - Configure the Settings section, based on the information that is shown in the Import Source Configuration Reference section down below
Step 8 - Click on the Save icon to save your settings
Step 9 - In the Verba web interface, navigate to Data > Data Management Policies
Step 10 - Click on the Add New Data Management Policy button at the top-right corner of the page
Step 11 - For the action, select Data Import
Step 12 - Under Available Import Sources, select the Import Source that you created, then click on the Add button just below the text field
Step 13 - Configure the policy details, based on the information that is shown in the Data Import Policy Configuration reference section down below
Step 14 - Set up how frequently the CDR Reconciliation should be run in the Scheduling section
Step 15 - Click on Save
Cisco-side configuration
The CUCM can be configured in a way to automatically export the contents of the CDR database to a defined SFTP storage. The Verba CDR reconciliation service imports the Cisco CDR data from this SFTP storage and compares the data found there with the data in the Verba database. For more information on how to set up this SFTP export task, refer to the Cisco resources above.
This article describes how to configure the CUCM to start collecting CDR information.
http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cucm/service/8_6_1/car/car/caranrpt.html
This article describes how to set up the CUCM to periodically export the collected CDR information to an SFTP storage.
Import Source Configuration reference
| Configuration Parameter Name | Description |
|---|---|
| CDR Files Folder | Path to where the Cisco CDR files are exported |
| Store SIP URI When Available | Store SIP URI instead of Number when available |
| Store Owner ID | Store Owner ID instead of Number/URI when available |
| Import Not Established Conversations | Imports not established conversations |
| On Completion | Defines what should happen to the files in the shared folder after Verba imported the CDRs Delete Files - The files will be deleted from the drive Move Files - The files can be moved to another location if a copy of them should be kept on the network drives |
| Move To (optional) | Specify where the files should be moved after Verba has processed them. Only available if the Move Files option is selected |
Data Import Policy Configuration reference
| Configuration Parameter Name | Description |
|---|---|
| Enable Recording Rules | Specifies if all data should be processed in the imported data set or just the records of the recorded users as configured in Verba |
| Enable CDR Reconciliation | Enables the reconciliation process on the imported CDRs |
| SIP URI Modification | This setting controls how the system should transform the SIP URI found in the CDRs. It has to be in line with the settings used for the recorder services |
| Send Alerts for Not Recorded Calls | If enabled, the service will send alerts if it detects not recorded conversations. The system alert message contains a summary of the number of not recorded conversations. It is useful if the administrators want to be notified of these errors. For standard users, you should use the built-in reporting option or the standard search page |
| Alerts Threshold [sec] | The system will send alerts only at this frequency (max) |
| Database Connection Retry Period [msec] | Defines the CDR database connections retry period in milliseconds |
| Media Length Check Threshold [sec] | The service compares the length of the media files to the duration of the conversations (based on the information available in the database) only for conversation where the media is longer than this value in seconds |
| Media Length Mismatch Threshold [%] | Defines a percentage value used in considering media length mismatch if the length difference is greater than this value. For instance, if the difference is greater than 3%, the system will mark the conversation with media length mismatch error |
| Ignore Calls Shorter Than [sec] | The service will ignore calls that were shorter than the defined duration |
| Execute Only on Selected Servers | If enabled, a specific server can be chosen that will run this policy |
Service level Configuration reference
Configuration Parameter Name | Description |
|---|---|
| Cisco CDR Column Filters | Custom filter based on Cisco CDR csv fields. If the defined field matches the specified regex then the record is skipped from processing. The config lines should be in field:regex format. Matching is case insensitive |
| Cisco External Device/IP Criteria | Reconciliation is done only on behalf of internal Cisco phones' side. By default each party is considered internal. This might lead to false matches (on behalf of remote extension) in case of inter-cluster or specially routed calls. To make sure we check the call only on "internal" extension's behalf, here a list of regexps can be defined which describes trunk, gw names or IPs. Matching is case insensitive |