CDR

From Taridium

(Difference between revisions)
Jump to: navigation, search
(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 DiagnosticsCDR 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 DiagnosticsCDR Viewer and filter your results using the filter dialog. Click on export search to export your search result.

Exporting all records*

Click on DiagnosticsCDR ViewerExport 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.

Personal tools
Namespaces
Variants
Actions
Toolbox