Avaya IP Office Phone (CSV). 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 Avaya IP Office

Avaya. PBX settings. Server mode

Replacing Avaya Delta Server

Recently Avaya have stripped off Delta Sever application which used to serve as SMDR. Our PBX Data Logger allows to replace this application and is very user friendly.

Configuring PBX Data Logger as a TCP client

Our software should work in the TCP client mode. It means that our software will initiate connection with the PBX and the PBX will work as a server. Add one or several PBX IP addresses here (the IP address of the (none)). The port number should match the port that you have defined within the PBX (180 in the example below).

1. Add a new configuration with the TCP data source (if you didn't it before).

TCP/IP Data Interface

2. Configure the TCP settings as shown below.

TCP Client Mode - Avaya IP Office

192.168.1.220

180

192.168.1.220:180

Selecting the correct parser for Avaya IP Office Phone (CSV)

Parser Selection For (none)

Avaya IP Office Phone (CSV)

Avaya IP Office Phone (CSV)

Data items

DescriptionData typeColumn name
Call timedatetimeCALL_TIME
Call durationdatetimeCALL_DURATION
Call duration (s)integerCALL_DURATION_S
Ring durationintegerRING
DirectionstringCALL_TYPE
DirectionstringDIRECTION
Is internalstringFLAG1
Caller phonestringCALLER_PHONE
ExtensionstringDNIS
ExtensionstringEXT
Called phonestringCALLED_PHONE
Dialed phonestringDIALED_PHONE
AccountstringACC
Call IDintegerCALL_ID
ContinuationstringFLAG2
Party1DevicestringPARTY1_DEVICE
Party1NamestringPARTY1_NAME
Party1DevicestringPARTY2_DEVICE
Party1NamestringPARTY2_NAME
Hold timeintegerHOLD_TIME
Park timeintegerPARK_TIME
Auth validstringFLAG3
Auth codestringAUTH
User chargedstringUSER_CHARGED
Call chargefloatCALL_CHARGE
CurrencystringCURRENCY
Amount at Last User ChangefloatLAST_CHARGE
Call unitsstringCALL_UNITS
Units at Last User ChangestringLAST_UNITS
Cost per UnitfloatCOST_UNIT
Mark upstringMARK_UP

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.