Sonus 2000 SBC SMDR setup and CDR format

This page shows how to get call records out of the Sonus 2000 SBC into Advanced PBX Data Logger: the connection settings, the parser to select and the 14 fields the logger extracts for reports or a database. The settings apply to our logger; other call accounting software may expect a different configuration.

Quick facts

Item	Sonus 2000 SBC
Interface	CDR files downloaded by FTP from the PBX or its server and parsed on arrival.
Port	21
Parser to select	Sonus 2000 SBC
Fields extracted	14

Configuring PBX

Retrieving Call Detail Records (CDR) from the RADIUS accounting server is relatively straight forward. Call Detail Records are stored on the RADIUS server in plain text in a directory named with the IP Address of the client SBC Edge system.

Each file in the directory represents one 24-hour period and is named for the date of the day it represents. Example: Filenames = detail-YYYYMMDD. The path for any particular CDR file is: /usr/local/var/log/radius/radacct/<client-ip-address>/detail-YYYYMMDD

Configuring PBX Data Logger

1. Create the new "File" data source.
2. Click "Actions → Add...".
3. Select the "FTP" file transfer protocol and configure connection with a FTP server on your PBX.
4. Adjust read options.

Adding a new file data source for Sonus 2000 SBC

Sonus 2000 SBC. Data source selection dialog.

Configuring FTP connection to Sonus 2000 SBC

192.168.0.254

/path/to/files/

det*.*

user

Adjusting read options for Sonus 2000 SBC

Selecting the correct parser for Sonus 2000 SBC

Sonus 2000 SBC

Data items

Description	Data type	Column name
Call time	datetime	CALL_TIME
Ring duration (s)	integer	RING_S
Ring duration	datetime	RING
Call type	string	CALL_TYPE
CDR call ID	string	FLAG1
CDR call type	string	FLAG3
CDR call number type	string	FLAG4
Call direction	string	DIRECTION
Call duration (s)	integer	CALL_DURATION_S
Call duration	datetime	CALL_DURATION
Caller phone	string	CALLER_PHONE
Dialed phone	string	DIALED_PHONE
Ext	string	EXT
Trunk	string	TRUNK

Sample record

As delivered by the system; phone numbers, names and public addresses are masked.

Mon Oct  3 16:40:50 2016
	NET-Log-Time = "Mon Oct  3 16:37:33 2016\n"
	Acct-Status-Type = Stop
	Acct-Session-Id = "147xxxxxxxxxxxxxxxxx"
	NET-Session-Ingress-CallId = 0
	NET-Session-Egress-CallId = 65535
	NET-Session-Generic-Id = 1085
	Acct-Multi-Session-Id = "147xxxxxxxxxxx"
	NET-Ingress-Signaling-Group = 1
	NET-Egress-Signaling-Group = 0
	NET-Ingress-Channel-Number = 1
	NET-Egress-Channel-Number = 0
	NET-Call-Origin = 1
	NET-Call-Type = 1
	NET-Routing-Table-Number = 1
	NET-Primary-Routing-Number = "018xxxxxxxx"

Reports and a database

Once records arrive, the logger writes them to a text file or to any ODBC database in real time, or hands them to the PBX Reports utility for manual, scheduled and e-mailed reports with a built-in web server. See exporting call log data to a database for the database setup.

Related Sonus systems

Snom ONE
Siemens iSDX Realitis
Sonus SBC (RADIUS,1000,2000)
Sphere VOIP Softswitch
All supported PBX systems

Note: Products and companies mentioned here are used only for definition and identification purposes and can be trademarks and/or registered trademarks of the respective companies.