User's Manual

ISG50 User’s Guide 720
CHAPTER 54
Call Detail Record (CDR)
54.1 Overview
This chapter shows you how to collect and manage Call Detail Records (CDRs) on the ISG50.
Call Detail Records (CDRs) are telephone records containing details such as the time of call,
duration of call, source telephone number and so on. The ISG50 has a built in CDR database that
automatically stores calls made to or from its extensions. You can search the CDR database to find
out details about your organization’s calls. You can also use an external database to store CDRs.
54.1.1 What You Can Do in this Chapter
•Use the CDR Configuration screen to configure where to store CDR information, an
administrator e-mail address to send alerts and CDR backup files for later viewing. See Section
54.2 on page 721.
54.1.2 What You Need to Know
The following terms and concepts may help you as you read through the chapter.
Local CDR Database
The local CDR database has limited capacity and when it is full it empties its contents into a
compressed file of the call records. This file is referred to as an “Aged File”. You can delete an “Aged
File” or forward it to an e-mail address where it can be reviewed at a later time. The CDR database
is then emptied. Whether you delete the aged file or send to an administrator, the ISG50 continues
to record telephone call details in an empty CDR database.
Another way to deal with the limited capacity on the local CDR database of the ISG50 is to actively
manage the CDR database. This requires you to create backups of the CDR database and send
them to an administrator via e-mail.
Viewing Aged Files
An “Aged File” is a compressed file with the extension “.tgz”. “.tgz” files can be decompressed with
data compression utilities for example 7-Zip. The result of decompressing this file are cdr.xxxxx.sql
or cdr.xxxxx.csv files. The .sql files can be managed via a PostgreSQL Database Management
System (DBMS).