Specifications

ShoreTel 7.5 Administration Guide C – 1
A
PPENDIX
C
Call Detail Record Reports
Call detail record (CDR) reports are used to review the ongoing call activity on the
ShoreTel system. Sections in this appendix include:
Overview
MySQL Database
CDR database
Generating a CDR Report
Interpreting CDR Reports
Overview
The ShoreTel system tracks all call activity and generates call detail records into a
database as well as into a text file on the ShoreWare server. The call detail records are
used to generate CDR reports. The system comes bundled with twelve CDR reports
based on data from the CDR database. In addition, the text files provide third-party call
accounting systems with a simple and standard way to access the call data.
If the ShoreWare server is not up and running, call detail records will not be generated,
and the associated calls cannot be presented in the CDR reports.
In the event of a WAN outage, CDR data is stored for up to two hours on the
distributed server. When WAN connectivity is restored, the stored data is forwarded to
the Headquarters database. After two hours, the distributed server deletes the data and
logs an error to the NT event log.
Call Accounting Service
The ShoreTel system has a call accounting service running on the main server that
generates call detail records into a database, as well as into a space-delimited text file
for use by third-party call accounting applications. The call accounting service is also
responsible for archiving all the CDR data.
The CDR files are located on the ShoreWare server in the following folders:
ShoreTel Data / Call Records 1—This contains call records for releases prior to
Shoreline3 Release 3.1k.