Asterisk CDR Reports Overview

This help file is for the old version of SAM Reports. New version bringsĀ more reports and a lot of new features.

There are new help files for CDR Reports for the new version -> SAM Reports2 :

CDR Pivot Reports (SAM Reports 2)

CDR Detailed Reports (SAM Reports 2)

SAM Reports gives you a full view of Call Detail Records from Asterisk PBX. CDR contains information about all the calls passing through the PBX. SAM Reports lets you view that data in an easy and customizable way, so that you can design your report anyway you like.

The structure of the main window is described in detail here.

There are four main areas covered in SAM Reports CDR Reports:

  1. Call Summary
  2. Channel (Extension) Summary
  3. Trunk Summary
  4. Contact (Caller ID) Summary and Unknown Caller-IDSummary

The report for each area is broken down into fields. Those fields are defined by the actual Asterisk CDR structure. SAM Reports lets you move those fields into different field areas and thus structure the report to your own needs.

CDR Call Summary shows all the data about any specific call, that is available from the Asterisk PBX.


Asterisk CDR Report - Duration By The Hour and The Day Of The Week

CDR Report - Duration By The Hour and The Day Of The Week


This view displays the data focused on extensions (channels) in the Asterisk PBX.


Asterisk CDR Report - Channels By The day Of the Week

Report - Channels By The day Of the Week


The trunks view shows detailed data about trunks. This can be useful when determining capacity for Asterisk PBX.


Asterisk CDR Report - Trunks by Direction

CDR Report - Trunks by Direction


Contacts view show call data with focus on caller-id that has been matched with a contact name.


Asterisk CDR Report Contacts By The Day Of The Week

CDR Report Contacts By The Day Of The Week


The unknown numbers report shows Asterisk call data with a focus on unknown caller-ID.


Asterisk CDR Reports - Unknown Caller ID By Month

CDR Reports - Unknown Caller ID By Month


The main building block of CDR Reports window are the fields. SAM Reports gives you the power to design your report in thousand ways by dragging and dropping the fields in different locations.

Four kinds of fields are: calculated , data , date and time and area-specific fields.

Calculated Fields are those whose value was not obvious from the Asterisk’s CDR logs. It had to be calculated taking into account additional data about the particular Asterisk PBX installation.

Those are: direction, origin and status.


CDR Direction Field (Incoming/outgoing)

CDR Calculated Field - Direction (Incoming/outgoing)


Direction determines whether the call was incoming or outgoing. This is a calculated field, which means that it’s value was determined by the SAM Reports upon processing the data from Asterisk PBX.

The possible values are:

  • Incoming call does not necessarily mean that the call came from the outside. It could be Peter calling Ann while sitting next to each other. Incoming, for Ann’s extension, just means that it received a call from some destination, no matter where from.
  • Outgoing call, also, does not assume placing a call to some destination outside a host PBX, it just denotes the direction which the call took.


Asterisk CDR Origin Field (Internal/External)

CDR Calculated Field - Origin (Internal/External)


destination.

The possible values are:

  • Internal call means that the caller and the callee are both the extensions of the same host PBX.
  • External call, in contrary, means that one of the sides in the call was from some other destination than our host PBX.

Status filed tells you whether the call was successful or not. It’s a calculated field.


Asterisk CDR Field Call Status

CDR Calculated Field - Call Status


It has three possible values:

  • Normal : the call was successful.
  • inc_noans : the call failed and it was an incoming call.
  • our_noans : the call failed and it was an outgoing call.

Data fields are original values taken form the Asterisk CDR logs. They have not been changed in any way, only aggregated to display accordingly to the current report view in the pivot gird.

They are: billable fields, duration fields an the count field.

They are “Billable Average” and “Billable Summary”.


CDR Data Fields - Billable Seconds

Asterisk CDR Data Field - Billable Seconds


hey show the accrued or average billable seconds for a given time period and currently selected fields in the pivot gird.

They are “Duration Average” and “Duration Summary”.


Asterisk CDR Fields Call Duration

CDR Data Field - Call Duration


Count filed tells you the numbers of calls for a given date, time and filed constellation in a report.


Asterisk CDR Field Count of Calls

CDR Data Field Count of Calls


Date and time fields are generated from CDR’s start and end time stamps. There are six date fields (Year, Quarter, WeekNo, Month Name, Day Of Month, Day Of Week ) and one time field (Hour).

These fields are the same for the queue reports as well. In that case they are generated form queue log’s time-stamps.

Year field carries just the year portion of a CDR’s time stamp.


Asterisk Report Date Field - Year

Report Date Field - Year


Quarter field breaks a year into four quarters.


Report Date Field - Quarter

Asterisk Report Date Field - Quarter


Week number filed displays the week number.

Asterisk Report Data Field - Week Number

Report Date Field – Week Number

This is a month name field.


Asterisk Report Date Field - Month Name

Report Date Field - Month Name


The day of the month field gives the number of a day in a month.


Asterisk Report Date Field - Day Of Month

Report Date Field - Day Of Month



The day of the week field display the weekday names.


Asterisk Report Date Field - Day Of Week

Report Date Field - Day Of Week


The hour field shows the hour in which the call occurred.


Asterisk Report Date Field - Hour

Report Date Field - Hour


Area specific fields are available each in it’s own corresponding area, so when looking at the “Channels Summary” there is a channels filed, and in the “Trunks Summary” view there is a trunks filed.

The channel filed shows all available channels (extensions) for the current selection in the grid.


Asterisk CDR Report Fields - Area Specific - Channels (Extensions)

CDR Report Fields - Area Specific - Channels (Extensions)


The trunk filed shows all available trunks for the current selection in the grid.


Asterisk CDR Report Fields - Area Specific - Trunk

CDR Report Fields - Area Specific - Trunk


The contact filed shows all available contacts.


Asterisk Report Fields - Area Specific - Contact

Report Fields - Area Specific - Contact


The trunk filed shows all available unknown caller IDs.


Asterisk Report Fields - Area Specific - Unknown Number

Report Fields - Area Specific - Unknown Number


Clicky Web Analytics