SMDR, CDR data captured by Advanced PBX Data Logger from Aastra Intelligate (tab)
This data is being extracted with help of the "Advanced PBX Data Logger" software only. It may not applicable for other software titles.
| Description | Data type | Column name |
|---|
| Ticked ID | integer | TICKED_ID |
| Serial ID | integer | SERIAL_ID |
| Sequence ID | integer | SEQUNCE_ID |
| PBX ID | integer | PBX_ID |
| User ID | integer | USER_ID |
| Subscriber | string | SUBSCRIBER |
| Name | string | NAME |
| Account | string | ACC |
| Direction | string | DIRECTION |
| Destination | integer | DEST |
| Destination name | string | DEST_NAME |
| Call type | string | CALL_TYPE |
| Call type name | string | CALL_TYPE_NAME |
| Handling | integer | HANDLING |
| Handling name | string | HANDLING_NAME |
| Call date | datetime | CALL_DATE |
| Call time | datetime | CALL_TIME_ONLY |
| Call date and time | datetime | CALL_TIME |
| Ring (sec) | integer | RING_S |
| Ring | datetime | RING |
| Call duration (sec) | integer | CALL_DURATION_S |
| Call duration | datetime | CALL_DURATION |
| Cost | float | COST |
| Pulses | integer | PULSES |
| PBX | string | FLAG1 |
| Node ID | string | FLAG2 |
| Board | string | FLAG3 |
| Port | string | FLAG4 |
| Extension | string | EXT |
| Channel group | integer | FLAG5 |
| Caller phone | string | CALLER_PHONE |
| Caller phone 2 | string | CALLER_PHONE2 |
| Dialed phone 1 | string | DIALED_PHONE1 |
| Dialed phone | string | DIALED_PHONE |
| PBX hops | integer | PBX_HOPS |
| Orig subscriber | string | FLAG6 |
| Orig user ID | integer | ORIG_USER_ID |
| Tickets | integer | TICKETS |
| Complete | integer | COMPLETE |
OIP server
The call data is stored as a file on the OIP server if so selected during the user-defined installation of the OIP server. In the standard settings a new file is written daily in the directory ...\aastra\oip\tax.
The files are created in .csv format. The file name is taxdata-jjjj-mm-dd.tax, with representing year-month-day. The Call Logging settings can be made in the OIP service Call Logging Driver.
In this case you can create the "File" data source in our software and process "tax" files.
Call logging over IP
The PBX can send the SMDR directly to the Advanced PBX Data Logger. Look at the settings below (Aims, AMS for Aastra 400).
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.
