Sonus 2000 SBC. SMDR/CDR data format and connection settings


This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not applicable for other software titles.

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.

Sonus 2000 SBC. Folders and files.

Configuring FTP connection to Sonus 2000 SBC

192.168.0.254

21

/path/to/files/

det*.*

user


Adjusting read options for Sonus 2000 SBC

Selecting the correct parser for Sonus 2000 SBC

Parser Selection For (none)

Sonus 2000 SBC

Sonus 2000 SBC

Data items

DescriptionData typeColumn name
Call timedatetimeCALL_TIME
Ring duration (s)integerRING_S
Ring durationdatetimeRING
Call typestringCALL_TYPE
CDR call IDstringFLAG1
CDR call typestringFLAG3
CDR call number typestringFLAG4
Call directionstringDIRECTION
Call duration (s)integerCALL_DURATION_S
Call durationdatetimeCALL_DURATION
Caller phonestringCALLER_PHONE
Dialed phonestringDIALED_PHONE
ExtstringEXT
TrunkstringTRUNK

Interested in reports for PBX usage?

We offer the PBX Reports utility with various manual, scheduled and email reports, built-in web-server, and other features. Look here

Want PBX call logs in a database?

This is the standard feature. The logger captures exports SMDR or CDR data in real-time to your database. Follow this link

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.