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

Parser Selection For (none)

Avaya IP Office 500 (CSV)

Avaya IP Office 500 (CSV)

Data items

DescriptionData typeColumn name
Call timedatetimeCALL_TIME
Call datadatetimeCALL_DATE
Call time onlydatetimeCALL_TIME_ONLY
Call durationdatetimeCALL_DURATION
Call duration (s)integerCALL_DURATION_S
Ring duration (s)integerRING_S
Ring durationdatetimeRING
Call typestringCALL_TYPE
DirectionstringDIRECTION
Is internalstringFLAG1
Caller phonestringCALLER_PHONE
DNISstringDNIS
SourcestringFLAG4
DestinationstringFLAG5
ExtensionstringEXT
Dialed phonestringDIALED_PHONE
AccountstringACC
Call IDintegerCALL_ID
ContinuationstringFLAG6
Party1 devicestringPARTY1_DEVICE
Party1 namestringPARTY1_NAME
Party2 devicestringPARTY2_DEVICE
TrunkstringTRUNK
Party2 namestringPARTY2_NAME
LinestringLINE
COstringCO
Party1 namestringFLAG2
Party2 namestringFLAG3
Hold timeintegerHOLD_TIME
Park timeintegerPARK_TIME
Auth validintegerAUTH_VALID
Auth codestringAUTH
User chargedstringUSER_CHARGED
Call chargefloatCOST
Call chargestringCURRENCY
Amount at last user changefloatAMOUNT_LAST_USER_CHANGE
Call unitsstringCALL_UNITS
Units at last user changestringUNITS_LAST_USER_CHANGE
Cost per unitfloatCOST_PER_UNIT
Mark upstringMARK_UP
External targeting causestringEXT_TARGET_CAUSE
External targeter IDstringEXT_TARGET_ID
External targeter numberstringEXT_TARGET_NUM
Server IP address of the caller extensionstringCALLER_SERVER_IP
Unique call id for the caller extensionstringCALLER_CALL_ID
Server IP address of the called extensionstringCALLED_SERVER_IP
Unique call id for the called extensionstringCALLED_CALL_ID
Call time (UTC)datetimeCALL_TIME_UTC

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.