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//detail-YYYYMMDD

Configuring PBX Data Logger

1. Create a new "File" data source.
2. Click "Actions - Add...".
3. Select "FTP" and configure connection with your FTP server.
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.
Sonus 2000 SBC

Configuring FTP connection to Sonus 2000 SBC
192.168.0.254
21
det*.*

Adjusting read options for 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

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.