CDR
From Taridium
(→Advanced CDR Processing) |
(→Advanced CDR Processing) |
||
| Line 40: | Line 40: | ||
== Advanced CDR Processing == | == Advanced CDR Processing == | ||
| - | If you need realtime CDR processing 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 [[CDR#Exporting_all_records.2A|Exporting all records]] section. | + | 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 [[CDR#Exporting_all_records.2A|Exporting all records]] section. |
Revision as of 09:26, 14 April 2009
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.
Contents |
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.
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
- calldate: Date and Time of call
- clid: Caller ID as set
- src: Caller ID number for the call source
- dst: Destination extension
- dcontext: Destination dialplan context
- channel: Channel used
- dstchannel: Destination channel if appropriate
- lastapp: Last called application
- lastdata: Last application data
- duration: Full duration of call including setup
- billsec: Duration of completed call
- disposition: Call end-status: ANSWERED, NO ANSWER, BUSY, FAILED
- amaflags: AMA Flags, if any
- accountcode: Account information for placed calls: usually of the format [extension]@default
- uniqueid: Unique call ID
- 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.
