Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
configuration:telephony:history [2018/10/16 11:25] – [Manual exporting history to CSV] acruz | configuration:telephony:history [2020/01/29 15:59] – asilva |
---|
:!: | :!: |
The export is done at the same time as the CDR. If there is a problem connecting to the ODBC (connection lost, table doesn't exist, other...) the cdr entries won't be exported. | The export is done at the same time as the CDR. If there is a problem connecting to the ODBC (connection lost, table doesn't exist, other...) the cdr entries won't be exported. |
| |
| |
| ===== Available fields ===== |
| * //uuid// - call identifier |
| * //aleg_uuid// - source channel identifier |
| * //bleg_uuid// - destination channel identifier |
| * //accountcode// - call last accountcode |
| * //userfield// - call last userfield |
| * //start_stamp// - call start time |
| * //answer_stamp// - call answer time |
| * //end_stamp// - call answer time |
| * //duration// - call duration |
| * //billsec// - call billsec, equals to answer time - end time |
| * //progress// - call ring time, equals to start time - answer time |
| * //ani// - original source caller identifier |
| * //aniii// - original source caller identifier 2 |
| * //caller_id// - source number and name identifier |
| * //caller_id_name// - source name |
| * //caller_id_number// - source number |
| * //channel_name// - source channel name |
| * //other_channel// - destination channel name |
| * //context// - last context name |
| * //extension// - last extension name |
| * //dnis// - original destination number |
| * //destination_number// - final destination number |
| * //hangup_cause// - hangup cause |
| * //last_app// - last dialplan application executed |
| * //last_arg// - last arguments in dialplan application executed |
| * //read_codec// - source channel read codec |
| * //write_codec// - source channel write codec |
| * //network_addr// - source network address |
| * //user_agent// - source user-agent |
| * //other_user_agent// - destination user-agent |
| * //price// - price |
| * //bill_amount// - billing amount |
| * //bill_rate// - billing rate |
| * //bill_rate_rule// - billing rate rule |
| * //bill_accountcode// - billing accountcode |
| * //bill_credit// - billing credit |
| * //dialplan_trace// - dialplan trace |
| * //sip_term_status// - sip termination status |
| * //sip_term_cause// - sip termination cause |
| * //sip_hangup_disposition// - sip hangup disposition |
| * //audio_in_mos// - incoming audio MOS |
| * //rtp_remote_audio_rtcp_port// - remote RTCP port used |
| * //remote_media_port// - remote RTP port |
| * //rtp_audio_in_packet_count// - number of incoming RTP pkts |
| * //rtp_audio_in_media_packet_count// - media of incoming RTP pkts |
| * //rtp_audio_in_skip_packet_count// - number of skipped incoming RTP pkts |
| * //rtp_audio_in_jitter_packet_count// - jitter for incoming RTP pkts |
| * //rtp_audio_in_dtmf_packet_count// - number DTMF incoming RTP pkts |
| * //rtp_audio_in_cng_packet_count// - number CNG incoming RTP pkts |
| * //rtp_audio_in_flush_packet_count// - number of flush incoming RTP pkts |
| * //rtp_audio_out_packet_count// - number of outgoing RTP pkts |
| * //rtp_audio_out_media_packet_count// - media of outgoing RTP pkts |
| * //rtp_audio_out_skip_packet_count// - number of skipped outgoing RTP pkts |
| * //rtp_audio_out_dtmf_packet_count// - number DTMF outgoing RTP pkts |
| * //rtp_audio_out_cng_packet_count// - number CNG outgoing RTP pkts |
| * //rtp_audio_rtcp_packet_count// - number of RTCP outgoing pkts |
| |
| |
| |