Specifications

Call Detail Record Reports
C – 2 ShoreTel, Inc.
Active CDR Database (CDR.mdb)
The call accounting service generates call detail records into the active CDR database
named
CDR.mdb. This file includes all call activity for the past 35 days. A nightly
routine automatically moves the call detail records for the current day into a monthly
archive database and deletes call detail records older than 35 days.
The CDR reports access the active CDR database (last 35 days of activity). If you want
to run CDR reports on older data, copy all the files onto a separate server, load Crystal
Reports, and change the name of the desired archive file.
Archive CDR Databases (CDR-mm-yyyy.mdb)
The call accounting service automatically archives call detail records into monthly
archive databases for the purpose of long-term storage. The names of these databases
have the form
CDR-mm-yyyy.mdb. In the interest of conserving disk space, only the last
three months are maintained. When a new month begins, the call accounting service
deletes the oldest monthly archive CDR database.
Legacy CDR Text Files
The call accounting service automatically generates a daily legacy CDR text file for use
by third-party call accounting applications. These packages typically provide numerous
reports, including:
• Call accounting, cost allocation
• Most frequently dialed numbers
• Most costly dialed numbers
• Most costly users
• Trunk utilization
• Toll fr a u d
The CDR*.log files are text files created daily at midnight. It contains call records from
midnight to midnight. Any call records that span the midnight hour will be recorded on
the day that calls are completed.
Format
The filenameformat for the daily legacy CDR log file is “CDR-MMDDYY.log” where
“MM,” “DD,” and “YY” are two-character, zero-padded month, day, and year numbers
respectively.
Call records are entered in the log file in the order of when the call was completed and
not when it began.
It is the responsibility of the third-party reporting application to delete the daily log
files.
The format of the record is column based, must be justified correctly, and end with a
carriage return and line feed. A single blank character is inserted between each data
field for readability.