AudioCodes Gateway (Extended). 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.

The parser is degisned for the following exact fields order. The configuration process is similar to AudioCodes Mediant 1000.

Call ID
Session ID
Report Type
Leg ID
Endpoint Type
Call Orig
Source IP
Destination IP
Remote IP
Source Port
Dest Port
Remote Port
Call Duration
Termination Side
Termination Raison
Setup Time
Connect Time
Release Time
Redirect Reason
IP Group Name
Transport Type
Termination Reason Category
IP Profile Name
Media Realm Name
SIP Termination Reason
SIP Termination Description
Caller Display ID
Callee Display ID
SIPInterface Name
Termination Side Yes No
ProxySet Name
Call Succes
Coder Type
Local Packet Loss
Local Round Trip Delay
Local Jitter
Remote Packet Loss
Remote Round Trip Delay
Remote Jitter
Local RTP IP
Local RTP Port
Remote RTP IP
Remote RTP Port
RTP IP DiffServ
Local MOS CQ
Latched RTP IP
Latched RTP Port
Coder Transcoding
MC Name
Source URI
Destination URI
Source URI Before Manipulation
Destination URI Before Manipula
Redirect URI
Redirect URI Before Manipulatio
Source Username
Destination Username
Source Username Before Manipula
Destination Username Before Man
Source Host
Destination Host
Source Host Before Manipulation
Destination Host Before Manipul
Remote SIP User Agent

Selecting the correct parser for AudioCodes Gateway (Extended)

AudioCodes Gateway (Extended)

Data items

Description	Data type	Column name
Call type	string	CALL_TYPE
Call time	datetime	CALL_TIME
Connect time	datetime	CONNECT_TIME
Release time	datetime	RELEASE_TIME
Ring	datetime	RING
Call Identifier	string	FLAG6
Call Originator	string	FLAG5
Direction	string	DIRECTION
Trunk	string	TRUNK
Ext	string	EXT
Dialed IP	string	DIALED_PHONE
Caller phone	string	CALLER_PHONE
Source URL	string	FLAG1
Destination URL	string	FLAG2
Call duration (sec)	integer	CALL_DURATION_S
Call duration	datetime	CALL_DURATION
Termination Reason	string	FLAG7
Caller Display ID	string	FLAG3
Callee Display ID	string	FLAG4
Call ID	string	CALL_ID
Session ID	string	SESSION_ID
Report Type	string	REPORT_TYPE
Leg ID	string	LEG_ID
Endpoint Type	string	ENDPOINT_TYPE
Call Orig	string	CALL_ORIG
Source IP	string	SOURCE_IP
Destination IP	string	DESTINATION_IP
Remote IP	string	REMOTE_IP
Source Port	string	SOURCE_PORT
Dest Port	string	DEST_PORT
Remote Port	string	REMOTE_PORT
Termination Side	string	TERMINATION_SIDE
Termination Raison	string	TERMINATION_RAISON
Redirect Reason	string	REDIRECT_REASON
IP Group Name	string	IP_GROUP_NAME
Transport Type	string	TRANSPORT_TYPE
Termination Reason Category	string	TERMINATION_REASON_CATEGORY
IP Profile Name	string	IP_PROFILE_NAME
Media Realm Name	string	MEDIA_REALM_NAME
SIP Termination Reason	string	SIP_TERMINATION_REASON
SIP Termination Description	string	SIP_TERMINATION_DESCRIPTION
Caller Display ID	string	CALLER_DISPLAY_ID
Callee Display ID	string	CALLEE_DISPLAY_ID
SIPInterface Name	string	SIPINTERFACE_NAME
Termination Side Yes No	string	TERMINATION_SIDE_YES_NO
ProxySet Name	string	PROXYSET_NAME
Call Succes	string	CALL_SUCCES
Coder Type	string	CODER_TYPE
Local Packet Loss	string	LOCAL_PACKET_LOSS
Local Round Trip Delay	string	LOCAL_ROUND_TRIP_DELAY
Local Jitter	string	LOCAL_JITTER
Remote Packet Loss	string	REMOTE_PACKET_LOSS
Remote Round Trip Delay	string	REMOTE_ROUND_TRIP_DELAY
Remote Jitter	string	REMOTE_JITTER
Local RTP IP	string	LOCAL_RTP_IP
Local RTP Port	string	LOCAL_RTP_PORT
Remote RTP IP	string	REMOTE_RTP_IP
Remote RTP Port	string	REMOTE_RTP_PORT
RTP IP DiffServ	string	RTP_IP_DIFFSERV
Local MOS CQ	string	LOCAL_MOS_CQ
Latched RTP IP	string	LATCHED_RTP_IP
Latched RTP Port	string	LATCHED_RTP_PORT
Coder Transcoding	string	CODER_TRANSCODING
MC Name	string	MC_NAME
Source URI	string	SOURCE_URI
Destination URI	string	DESTINATION_URI
Source URI Before Manipulation	string	SOURCE_URI_BEFORE_MANIPULATION
Destination URI Before Manipula	string	DESTINATION_URI_BEFORE_MANIPULA
Redirect URI	string	REDIRECT_URI
Redirect URI Before Manipulatio	string	REDIRECT_URI_BEFORE_MANIPULATIO
Source Username	string	SOURCE_USERNAME
Destination Username	string	DESTINATION_USERNAME
Source Username Before Manipula	string	SOURCE_USERNAME_BEFORE_MANIPULA
Destination Username Before Man	string	DESTINATION_USERNAME_BEFORE_MAN
Source Host	string	SOURCE_HOST
Destination Host	string	DESTINATION_HOST
Source Host Before Manipulation	string	SOURCE_HOST_BEFORE_MANIPULATION
Destination Host Before Manipul	string	DESTINATION_HOST_BEFORE_MANIPUL
Remote SIP User Agent	string	REMOTE_SIP_USER_AGENT

Interested in reports for PBX usage?

With our PBX Reports utility, you get manual, scheduled, and email reporting options, a built-in web server, and other functionalities. Set up your call accounting system for AudioCodes Gateway (Extended). Look here

Want PBX call logs in a database?

Real-time capture and export of SMDR or CDR data to your database is a standard feature of the logger. 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.