Reports

From VoIPmonitor.org

Category:GUI manual

Reports

Reports include daily reports, instant report generator, call summary, QoS report, and CDR simplified view.

Daily Email Reports

Daily email reports resemble alerts but send once per day and can include daily charts based on criteria.

Daily reports configuration

RTP Daily Report

Summarizes RTP metrics: MOS, packet loss, jitter, delay (PDV), duration, one-way, and missing RTP.

RTP daily report example

CPS Daily Report

CPS (Calls Per Second) report provides daily statistics of call volume rate. Reports maximum and average CPS over the selected period.

  • Navigate to GUI > Reports > Configure Daily Reports
  • Select CPS as the report type to receive periodic email summaries of maximum and average CPS

Daily Charts Report

Generates daily chart statistics. Create multiple charts per report, filtered by CDR criteria (e.g., SIP trunks).

Daily charts report configuration

Chart creation dialog allows custom charts with filters on numbers, IP, RTP stats.

Chart creation dialog

Preview results or send test emails via buttons.

Report preview and test buttons
Report preview result

CDR Summary Report

The CDR Summary report provides a daily summary of call data with optional billing cost information. This is the report type to use when you want to see outbound call costs per trunk.

To generate a report with costs:

  1. Navigate to GUI > Reports > Configure Daily Reports
  2. Select CDR summary as the report type
  3. Enable the Price columns option to include billing costs
  4. Configure the date range and any filters (e.g., specific trunks, IP addresses)
  5. Save the report configuration

Note: For costs to appear in the report, the billing system must be configured (see Billing Configuration) and costs must be calculated for the CDRs in your database. See CDR View for how to verify costs are being calculated by enabling the PRICE column.

Report Generator

Creates reports from historical data by criteria.

  • "Only CDR with RTP" checkbox: Reports connected calls only (ASR always 100%) or all CDRs.
Report generator form

Results table appears below form after selecting date, IP ranges, QoS parameters.

Report generator results

Call Summary

Overview grouped by source/destination IPs, focusing on signaling metrics: ASR, ACD, total duration, call count. Toolbar filters by date range, source/destination numbers.

Call summary report

Export Column Reference

The following tables describe columns available in CSV exports.

Basic Metrics:

Column Description
sipip / sip_ip Source IP address
cnt_all Count of CDRs
cnt_connected Count of connected CDRs
duration_all Sum of connected seconds
acd_all Average Call Duration
asr_all Answer Seizure Ratio
ner_all Network Effectiveness Ratio
seer_all Session Establishment Effectiveness Ratio
short_60 Ratio (%) of CDRs with connect duration < 60s
short_20 Ratio (%) of CDRs with connect duration < 20s
mos_all MOS average (min from caller/called)
response_time_100_all Response time from INVITE to 100/183 (ms)
pdd_all Post Dial Delay (time to hear announcement)
packets_lost_all Lost packets count
jitter_all Average RTP jitter (max from caller/called)
delay_all Average of median jitter (PDV in ms)

MOS XR Columns (from RTCP-XR reports):

Column Description
mos_xr_avg_all MOS XR average (min of caller/called)
mos_xr_avg_caller_all MOS XR average for caller stream
mos_xr_avg_called_all MOS XR average for called stream
mos_xr_min_all MOS XR minimal (caller/called)
mos_xr_min_caller_all MOS XR minimal for caller stream
mos_xr_min_called_all MOS XR minimal for called stream

RTCP Columns:

Column Description
rtcp_maxfr Maximum fraction loss reported in RTCP
rtcp_maxjitter Maximum jitter reported in RTCP
rtcp_avgfr Average fraction loss reported
rtcp_avgjitter Average jitter reported in RTCP
rtcp_maxrtd Max round trip delay (ms)
rtcp_avgrtd Average round trip delay (ms)

Silence/Clipping Columns (requires silence detection enabled):

Column Description
mos_silence_avg_all MOS during silence periods (min of caller/called)
mos_silence_avg_caller_all MOS during silence periods (caller stream)
mos_silence_avg_called_all MOS during silence periods (called stream)
mos_silence_min_all MOS minimal during silence
mos_silence_min_caller_all MOS minimal during silence (caller stream)
mos_silence_min_called_all MOS minimal during silence (called stream)
silence_all Percentage of call that was silence
silence_end_all Seconds of silence before BYE packet
clipping_all Number of clipped frames (requires clippingdetect=yes)

Other Columns:

Column Description
mos_lqo_caller_all MOS listening quality objective (caller)
mos_lqo_called_all MOS listening quality objective (called)
sip_hostname Hostname from DB IP lookup (if enabled)
sip_hostname_color Color setting from DB IP lookup
id IP address with underscores instead of dots

QoS Report

Similar to call summary but emphasizes RTP stats: MOS, jitter, delay, packet loss. Toolbar filters by date range, IP range.

QoS report

Call Detail Records

Simplified CDR interface showing IPs and numbers, with quick toolbar filters.

Simplified CDR view

CSV Export via Crontab Scheduler

You can export CDRs to a local directory on a schedule instead of (or in addition to) receiving them via email. This is useful for automated processing, archiving, or integration with external systems.

Configuration Steps

1. Set the Export Folder
  • Navigate to GUI > Settings > System Configuration > Advanced
  • Set "Folder for export CSV" to your desired directory (e.g., /var/backups/cdrs)
  • Optionally set "CSV name prefix" for filename prefixes
  • Optionally set "Delete CSV after X days" for automatic cleanup
2. Create a Crontab Scheduler Task
  • Navigate to GUI > Settings > Crontab Scheduler
  • Create a new task with:
    • Type: Report type (Call Summary, Report Generator, etc.)
    • Schedule: Frequency (hourly, daily, weekly, or cron expression)
    • Report parameters: Date range, IP ranges, etc.
3. Verify Permissions
  • Web server user (www-data or apache) must have write access to export folder
  • Ensure sufficient disk space for accumulated files

For custom export formats, consider using the Web API instead.

Troubleshooting Scheduled Reports

If scheduled reports are not sent automatically but manual generation works, check these common causes:

Timezone Mismatch

The GUI and server OS must use the same timezone. If they differ, scheduled tasks may run at wrong times or appear to be skipped.

Symptoms:

  • Manual report generation works immediately
  • Scheduled reports appear configured but don't run at expected time

Solution:

1. Check GUI timezone
Navigate to GUI > Settings > System Configuration > National > Timezone
2. Check OS timezone
date
timedatectl
3. Align timezones
# Change OS timezone to match GUI (example)
timedatectl set-timezone Europe/Prague
4. Verify system cronjob
crontab -l
# Should contain:
# * * * * * root php /var/www/html/php/run.php cron

Other Common Causes

  • Email delivery issues: Check MTA logs with mailq and tail /var/log/mail.log
  • Incorrect schedule: Verify task has valid "Next run" time in the future
  • Stuck tasks: Edit and save the task again to reset its state

See Also

AI Summary for RAG

Summary: VoIPmonitor reports system provides daily email reports (RTP summaries, CPS reports with max/average calls per second, daily charts, CDR summary with optional price columns for billing costs), a report generator for historical data analysis, call summary grouped by IP addresses, QoS reports emphasizing RTP metrics, and simplified CDR views. CSV exports can be automated via crontab scheduler. Common troubleshooting involves timezone alignment between GUI and OS settings.

Keywords: reports, daily reports, RTP, CPS, calls per second, charts, CDR summary, price columns, billing costs, call summary, QoS, ASR, ACD, NER, MOS, CSV export, crontab scheduler, timezone

Key Questions:

  • What types of reports does VoIPmonitor provide?
  • How to configure daily email reports with billing costs?
  • How to enable price columns in CDR summary reports?
  • What columns are available in CSV export?
  • How to export CDRs to CSV automatically?
  • Why are scheduled reports not being sent?