ZyXEL Communications ISG50 User Manual

ISG50 User’s Guide

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.

• 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 

.

The following terms and concepts may help you as you read through the chapter.

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.

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).