CDR

From Taridium

Revision as of 09:18, 14 April 2009 (view source) Webmaster (Talk | contribs) ← Older edit		Revision as of 09:19, 14 April 2009 (view source) Webmaster (Talk | contribs) (→Advanced CDR Processing) Newer edit →
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.	+	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 refer to the xxx section.

---

Revision as of 09:19, 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 1 Viewing Records 2 Exporting Records 2.1 Exporting filtered Search Results 2.2 Exporting all records* 3 CDR Fields 4 Advanced CDR Processing

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

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 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 refer to the xxx section.