CDR

From Taridium

Revision as of 15:09, 28 January 2010

A CDR or call detail record is a record representing a unit of traffic handled by ipbx. All calls without exception are recorded in the CDR database. Usually, but not necessarily this database is local to the PBX. Some calls will yield multiple CDR entries, for example when call is forwarded/transferred. CDR data, can optionally be stored in a separate database on the system or on a remote host depending on configuration.

Viewing Records

To see your CDR records, click on Diagnostics → CDR Viewer. The initial view will be limited to 100 records. You can change the filter settings by modifying your search criteria and adjusting the number of returned records. Blue shaded columns also allow you to view additional information, by moving your mouse pointer over it. This includes: Detailed Date & Time information, Source Channel, Destination Channel, Bill Duration, Application Data and User Field.

Clicking on the File:Yellowarrow.gif icon will display the complete record as stored in the database. If available, the icon will also allow you to display a map of the number found.

Exporting Records

Records can easily be exported via the administrator's interface as CSV files.

Exporting filtered Search Results

Quite often it makes sense to filter calls, before exporting them. Click on Diagnostics → CDR Viewer and filter your results using the filter dialog. Click on export search to export your search result.

Exporting all records*

Click on Diagnostics → CDR Viewer → Export Records and enter a descriptive filename for your download. Export of records is limited to 100,000 records.

CDR Fields

1. calldate: Date and Time of call
2. clid: Caller ID as set
3. src: Caller ID number for the call source
4. dst: Destination extension
5. dcontext: Destination dialplan context
6. channel: Channel used
7. dstchannel: Destination channel if appropriate
8. lastapp: Last called application
9. lastdata: Last application data
10. duration: Full duration of call including setup
11. billsec: Duration of completed call
12. disposition: Call end-status: ANSWERED, NO ANSWER, BUSY, FAILED
13. amaflags: AMA Flags, if any
14. accountcode: Account information for placed calls: usually of the format [extension]@default
15. uniqueid: Unique call ID
16. userfield: Account information for received calls: usually of the format [extension]@default

Advanced CDR Processing

If you need realtime CDR processing/backup you can use the readily available MySQL interface or configure the ODBC drivers. The relevant database name is ipbx (unless CDR records are stored separately) and the table name is cdr. For a description of columns/fields refer to the Exporting all records section.