Splicecom Maximiser. 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 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 (4001 in the example below).
1. Add a new configuration with the TCP data source (if you didn't it before).
2. Configure the TCP settings as shown below.
192.168.1.220
4001
192.168.1.220:4001
Changing the Call Logging Password
The Call Logging Password configurable in PBX can be used to protect access:
From the Management information list select System
Beside the Call Logging Password field click on Change
In the Script Prompt enter the password required
Select OK
Re-enter your password to confirm the change
Select OK
Submit the change
No logging output will occur without the Call Logging password being sent Advanced PBX Data Logger. So, you should activate the data query plugin and specify the password (fig. 2,3)
Data items
Description
Data type
Column name
Call time
datetime
CALL_TIME
Cost centre (user or department)
string
FLAG1
Trunk (B)
string
TRUNK_B
Trunk (A)
string
TRUNK_A
Call type
string
DIRECTION
Trunk
string
TRUNK
Extension
string
EXT
Caller number
string
CALLER_PHONE
Caller name
string
FLAG3
Dialed number (A)
string
DIALED_PHONE
On behalf of (B)
string
ONBEHALFOF_B
Name (B)
string
NAME_B
Number (B)
string
NUMBER_B
Call duration (s)
integer
CALL_DURATION_S
Call duration
datetime
CALL_DURATION
Connected time (s)
integer
CONNECTED_TIME
Ring duration
datetime
RING
Account name
string
ACC
Account number
string
FLAG5
Connected status
string
FLAG6
Informational Field (B)
string
REM_B
Original cost centre
string
ORIG_COST_CENTRE
Call Record GUID
string
FLAG2
Secondary transferred call
string
TRANSFERED_CALL
Transferred call GUID
string
TRANSFER_CALL_GUID
Queuing time
string
QUEUING_TIME
Distributing time
string
DISTRIBUTING_TIME
Agent ringing
string
AGENT_RINGING
Call time
datetime
CALL_TIME_GMT
Dialed number (B)
string
DIALED_B
Outgoing call (B)
string
OUT_B
Cost centre (B)
string
COST_CENTRE_B
Informational Field (A)
string
REM_A
On behalf of (A)
string
ONBEHALFOF_A
Remote name (A)
string
REMOTE_NAME_A
Remote name (B)
string
REMOTE_NAME_B
Customer ID
string
CUSTOMER_ID
Tariff ID
string
TARIFF_ID
Reason code (A)
string
REASON_CODE_A
Reason code (B)
string
REASON_CODE_B
On behalf of number (A)
string
ONBEHALFOF_NUMBER_A
On behalf of number (B)
string
ONBEHALFOF_NUMBER_B
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.