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

Configuring PBX Data Logger

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 Avaya IP Office). The port number should match the port that you have defined within the PBX (180 in the example below).

TCP Client Mode - Avaya IP Office
180
180

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.

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
ContinuationstringFLAG2
Party1 devicestringPARTY1_DEVICE
Party1 namestringPARTY1_NAME
Party2 devicestringPARTY2_DEVICE
TrunkstringTRUNK
Party2 namestringPARTY2_NAME
LinestringLINE
COstringCO
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

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.