Asterisk CDR Reports | Asterisk Reports Made Simple

Asterisk CDR Reports Overview

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:

Call Summary
Channel (Extension) Summary
Trunk Summary
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 Calls Summary

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

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

CDR Channels (Extensions) Summary

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

Report - Channels By The day Of the Week

CDR Trunks Summary

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

CDR Report - Trunks by Direction

CDR Contacts Summary

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

CDR Report Contacts By The Day Of The Week

CDR Unknown Phone Numbers Summary

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

CDR Reports - Unknown Caller ID By Month

CDR Report Fields

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

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.

Direction Field

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.

Origin Field

CDR Calculated Field - Origin (Internal/External)

This filed is also calculated by SAM Reports. Origin may be internal and external. Internal call is a call between extensions of the same Asterisk PBX. External call is a call between local extension and an outside extension, 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 Field

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

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

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.

Billable Fields

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

Asterisk CDR Data Field - Billable Seconds

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

Duration Fields

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

CDR Data Field - Call Duration

Count Field

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

CDR Data Field Count of Calls

Date and Time Fields

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

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

Report Date Field - Year

Quarter Field

Quarter field breaks a year into four quarters.

Asterisk Report Date Field - Quarter

WeekNo Field

Week number filed displays the week number.

Asterisk Report Data Field - Week Number

Report Date Field - Week Number

Month Name Field

This is a month name field.

Report Date Field - Month Name

Day Of Month Field

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

Report Date Field - Day Of Month

Day Of Week Field

The day of the week field display the weekday names.

Report Date Field - Day Of Week

Hour Field

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

Report Date Field - Hour

Area-specific Fields

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.