Avaya Utility Server : CDR Collector

avaya-button-small.jpgThe Avaya Utility Server is a Linux Server that is designed to provide many different functions within an Avaya Aura environment. The Utility Server can provide settings to IP phones and serves as a TFTP server to upgrade firmware on hardware components. It is very handy to have and there is no license required.



Avaya Utility Server CDR Collector

The Avaya Utility Server has a Linux RPM installed that supports and enables the Call Detail Record (CDR) Collector. The CDR Collector daemon will copy CDR text files from the active server interface of your Communication Manager instance over to the Utility Server for processing. 

Name        : Util_CDR                     Relocations: (not relocatable) 
Version      : 7.0                               Vendor: (none) 
Release      : 03                            Build Date: Wed 01:13:25 PM EDT 
Group        : Avaya                         Source RPM: Util_CDR-7.0-03.src.rpm 
Size         : 37770                            License: Avaya 
Signature    : (none) 
Summary      : Util_CDR 
Description : Utility Server - CDR Collector and Importer 


The following scripts are associated with the CDR Collector daemon on the Utility Server: 

Util_CDR                  /etc/cron.d/CDR_Daily 
Util_CDR                  /etc/cron.d/CDR_ExportPurge 
Util_CDR                  /etc/cron.d/CDR_Monthly 
Util_CDR                  /etc/cron.d/CDR_Weekly 
Util_CDR                  /etc/cron.d/Compress_CDRs 
Util_CDR                  /etc/cron.d/Get_CM_CDRs 
Util_CDR                  /etc/cron.d/Import_CDRs 
Util_CDR                  /etc/logrotate.d/Util_CDR 
Util_CDR                  /opt/util/bin/CDR_Backup.sh 
Util_CDR                  /opt/util/bin/CDR_Configure.sh 
Util_CDR                  /opt/util/bin/CDR_ExportPurge.sh 
Util_CDR                  /opt/util/bin/CDR_Restore.sh 
Util_CDR                  /opt/util/bin/Compress_CDRs.sh 
Util_CDR                  /opt/util/bin/Get_CM_CDRs.sh 
Util_CDR                  /opt/util/bin/Import_CDRs.sh 
Util_CDR                  /opt/util/bin/Longest_Calls.php 
Util_CDR                  /opt/util/bin/Most_Active.php 
Util_CDR                  /opt/util/bin/Most_Dialled.php 
Util_CDR                  /opt/util/bin/reports.php 
Util_CDR                  /var/www/html/piechart.php 


  • The Utility Server will attempt to collect CDR records from Communication Manager every 30 minutes as outlined in /etc/cron.d/Get_CM_CDRs.sh.
  • The CDR records are then imported at 10 minutes past every hour as to not conflict the with Get_CM_CDRs.sh script. 
  • The CDR Collector daemon will log its attempts to collect the CDR from Communication Manager into the following file /var/log/CDR/collector.log.
  • This file is able to be read from the web interface of the Utility Server or from an SSH session into the Linux Server. 

 

Add CDR Login to Communication Manager

Using the Communication Manager SMI web interface - click on Administrator accounts and by default the Add Login radio button will be selected. Click the radio button next to CDR Access Only and then click Submit. This login will be used by the Utility Server to copy files from Communication Manager using Linux Secure Copy Protocol (SCP). 

 avaya-utility-manager-cdr-collector.jpg


Fill out the Login name field and set a password for your user. Make a note of the these credentials as you will need them when administering the CDR settings on the Utility Server.

avaya-utility-manager-cdr-collector.jpg

 

Communication Manager's CDR Parameters

Communication Manager will need to be setup to log its CDR message to disk using a customized CDR format that lines up with what the Utility Server is looking for. The layout for the CDR format will be done on page 2 of the change system-parameters cdr form. This format is also outlined at downloads.avaya.com/css/P8/documents/101013948 in Appendix B. 

change-system-parameters-cdr.jpg

 change-system-parameters-cdr.jpg

If you connect to Communication Manager using SSH and login to port 22 you can view the CDR records that are being written to disk. Simply login to Communication Manager with the credentials you created on the Communication Manager SMI web interface. The CDR records will be in /var/home/ftp/CDR.

 

Collect CDR Records

Navigate to the System Management Interface (SMI) of your Avaya Utility Server. Then click on "Call Detail Recording" under Application Control. Fill out the username and password you created in Communication Manager in the text boxes provided and then click the button for "Enable Password Mode". 

avaya-utility-manager-cdr-collector.jpg

If your collector service was already running before you input your password you will need to stop and start the collector service. While on this page click the buttons shown to enable the rest of the CDR services, Collector, Importer, Exporter and Compressor. All services should show in green as RUNNING

Be patient for the CDR records to be copied from Communication Manager over to the Utility Server. By default the Utility Server will only check for new records every 30 minutes, and those records if they are found will be imported into the PostgreSQL database running on the Utility Server. 

View CDR Reports

Once data has been collected by the Avaya Utility Server you can use the following links on the Utility Server to view your CDR records.  

avaya-utility-manager-cdr-collector.jpg

 

Example of a CDR report looking at "All Records" and selecting "Select Customer Number":

PBX 

Date 

Time 

Duration (HMMSS) 

Originating Number 

Dialed Number 

PBX 

2017-04-01 

16:59:00 

242 

3006 

2999 

PBX 

2017-09-01 

10:08:00 

234 

3001 

2999 

PBX 

2016-07-10 

12:31:00 

224 

2999 

2999 

PBX 

2016-02-12 

13:21:00 

217 

3006 

2999 

PBX 

2016-12-10 

12:36:00 

201 

2999 

2999 

 

 Example of pie chart graph looking at top 10 most active numbers:

avaya-utility-manager-cdr-collector.jpg

Avaya Communication Manager