Overview

CDR Pivot Reports let you look at Asterisk CDR data in a Business Intelligence form. The data gathered from Asterisk CDR log files (Master.csv*) is processed and broken down into fields. It is then aggregated to be made presentable in a pivot grid.

You see more about the general organization of pivot reports here. This section focuses on CDR pivot reports.

CDR Pivot Report Types

CDR Pivot Reports commands are available from the “main menu” and “most used commands” parts of the application’s main window, the “Pivot Reports” command.

SAM Reports 2 CDR Pivot Report Types

SAM Reports 2 CDR Pivot Report Types

There are six types of report configurations:

Asterisk CDR Calls Pivot Report

CDR Call Summary shows all the data about any specific call, that is available from the Asterisk PBX. Here’s an example that shows some hours (hour field is filtered) by day of week, displayed in a column chart.


Asterisk CDR Report - Pivot - Calls

Asterisk CDR Report - Pivot - Calls


Asterisk CDR Trunks and Channels Pivot Report

This reports also contains trunks and channels. This example shows 4 distinct channels (channel field is filtered)  and their relation to top 5 trunks, displayed by a pie chart.

Asterisk CDR Report - Pivot - Trunks and Channels

Asterisk CDR Report - Pivot - Trunks and Channels

Asterisk CDR Channels Pivot Report

This reports is just like CDR Calls reports, but it also contains channels. The example below shows top 5 channels (by count) organized by week days and displayed in stacked bar chart.

Asterisk CDR Report - Pivot - Channels (extensions)

Asterisk CDR Report - Pivot - Channels (extensions)

Asterisk CDR Trunks Pivot Report

This reports is just like CDR Calls reports, but it also contains trunks. The example below shows top 5 trunks (by count), organized by the destination context and displayed in stacked column chart. Destination context field is filtered.

Asterisk CDR Report - Pivot - Trunks

Asterisk CDR Report - Pivot - Trunks

Asterisk CDR Contacts Pivot Report

This reports is just like CDR Calls reports, but it also contains contacts (they were gathered from CDR caller ID). here you can see number of calls per contact distributed by hour, in a stacked area chart.

Asterisk CDR Report - Pivot - Contacts

Asterisk CDR Report - Pivot - Contacts

Asterisk CDR Phone Numbers Pivot Report

This reports is just like CDR Calls reports, but it also contains phone numbers(they were gathered from CDR caller ID, source or destination fields). On the example below you can see my own Asterisk reports for phone numbers, organized by a summary of call duration and count of calls, split by week days, and I’m only including incoming calls (direction field is filtered).  The report is displayed using line chart. The number on the top is my mom :) .

Asterisk CDR Report - Pivot - Phone Numbers

Asterisk CDR Report - Pivot - Phone Numbers

CDR Pivot Fields

You can find more information about SAM Reports 2 fields here. In this section we will list all CDR pivot fields:

Clicky Web Analytics