Configuring Lync - SfB CDR Reconciliation

For an overview of the CDR Reconciliation feature, refer to the CDR reconciliation article.

The configuration of the CDR Reconciliation was changed in Verba version 9.0. The settings need to be manually moved from the server configuration to the import policy configuration when upgrading systems from earlier releases. Before an upgrade, save your current CDR connection configuration and reimplement it in an Import policy after the upgrade. This information in earlier versions can be found in the server configuration of the Media Repository server under CDR and Archived Content Importer

Configuration steps

Follow the steps below to configure CDR reconciliation:

Step 1 - 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 2 - In the Verba web interface, navigate to Data > Import Sources

Step 3 - Click on the Add New Import Source button at the top-right corner of the page

Step 4 - Define the name of the Import Source. This name identifies this source in the system

Step 5 - For the type, select Lync/SfB CDR

Step 6 - Configure the Settings section, based on the information that is shown in the Import Source Configuration Reference section down below

Step 7 - Click on the Save icon to save your settings

Step 8 - In the Verba web interface, navigate to Data > Data Management Policies

Step 9 - Click on the Add New Data Management Policy button at the top-right corner of the page

Step 10 - For the action, select Data Import

Step 11 - Under Available Import Sources, select the Import Source that you created, then click on the Add button just below the text field

Step 12 - Configure the policy details, based on the information that is shown in the Data Import Policy Configuration reference section down below

Step 13 - Set up how frequently the CDR Reconciliation should be run in the Scheduling section

Step 14 - Click on Save

Import Source Configuration reference

Configuration Parameter NameDescription
Database HostnameHostname or IP address of the SfB/Lync SQL Server
Database NameName of the CDR database (RTC), e.g. LcsCDR
Database QoE NameName of the database that holds the QoE data. Default value is QoEMetrics
Database LoginUsername for SQL authentication (Read right required only)
Database PasswordPassword for SQL authentication
Failover PartnerHostname or IP address of the SQL Server mirroring failover partner
Database Multi-Subnet FailoverShould be enabled if multi-subnet failover is turned on in the database
Windows AuthenticationEnables Windows authentication for the SQL Server connection, the system will use the Windows service credentials configured for the Verba CDR and Archived Content Importer Service
SSL EncryptionEnables SSL based SQL Server connections
Import not Established ConversationsAllows importing not established calls such as not answered, busy, etc.
Lync VersionVersion of the system, the following values apply:
  • Lync 2010
  • Lync 2013 / Skype for Business
Use QoE MetricsQoE metrics helps to determine RTP packet utilization and discard calls where no, or just a few RTP packets were sent
Import Conference ParticipantsData of conference participants can be collected if the meeting was hosted in the home pool where the CDR info comes from. With this option set to yes, conference participant information will be imported.

Data Import Policy Configuration reference

Configuration Parameter NameDescription
Enable Recording RulesSpecifies 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 ReconciliationEnables the reconciliation process on the imported CDRs
SIP URI ModificationThis 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 CallsIf 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
Skip Calls without QoE ReportsThe service will ignore calls where no QoE reports can be found
Execute Only on Selected ServersIf enabled, a specific server can be chosen that will run this policy