Differences

This shows you the differences between two versions of the page.

--- configuration:telephony:history [2014/01/16 15:20] – admin
+++ configuration:telephony:history [2022/12/13 10:35] (current) – admin
@@ Line 10: / Line 10: @@
 You can select the columns to export. In order to select the variables to export do:
-  * Click on the icon behind the text //Show variables//
+  * Click on the icon in the left of text //Export//
   * to add a new column, click on the //add// button. Set the **column** name and **variable** field to export.
   * to delete a column, click on the //delete// button
@@ Line 34: / Line 34: @@
 :!:
 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
+===== Hangup causes =====
+When a call is terminate in the CDR is stored the hangup cause. It can be one of the following:
+    * //UNSPECIFIED// - Unspecified. No other cause codes applicable.
+    * //UNALLOCATED_NUMBER// - Unallocated (unassigned) number.
+    * //NO_ROUTE_TRANSIT_NET// - No route to specified transit network.
+    * //NO_ROUTE_DESTINATION// - No route to destination.
+    * //CHANNEL_UNACCEPTABLE// - Channel unacceptable.
+    * //CALL_AWARDED_DELIVERED// - Call awarded, being delivered in an established channel.
+    * //NORMAL_CLEARING// - Normal call clearing.
+    * //USER_BUSY// - User busy.
+    * //NO_USER_RESPONSE// - No user responding.
+    * //NO_ANSWER// - No answer from user.
+    * //SUBSCRIBER_ABSENT// - Subscriber absent.
+    * //CALL_REJECTED// - Call rejected.
+    * //NUMBER_CHANGED// - Number changed.
+    * //REDIRECTION_TO_NEW_DESTINATION// - Redirection to new destination.
+    * //EXCHANGE_ROUTING_ERROR// - Exchange routing error.
+    * //DESTINATION_OUT_OF_ORDER// - Destination out of order.
+    * //INVALID_NUMBER_FORMAT// - Invalid number format (address incomplete).
+    * //FACILITY_REJECTED// - Facilities rejected.
+    * //RESPONSE_TO_STATUS_ENQUIRY// - Response to STATUS INQUIRY.
+    * //NORMAL_UNSPECIFIED// - Normal, unspecified.
+    * //NORMAL_CIRCUIT_CONGESTION// - No circuit/channel available.
+    * //NETWORK_OUT_OF_ORDER// - Network out of order.
+    * //NORMAL_TEMPORARY_FAILURE// - Temporary failure.
+    * //SWITCH_CONGESTION// - Switching equipment congestion.
+    * //ACCESS_INFO_DISCARDED// - Access information discarded.
+    * //REQUESTED_CHAN_UNAVAIL// - Requested circuit/channel not available.
+    * //PRE_EMPTED// - Preempted call.
+    * //FACILITY_NOT_SUBSCRIBED// - Requested facility not subscribed.
+    * //OUTGOING_CALL_BARRED// - Outgoing calls barred.
+    * //INCOMING_CALL_BARRED// - Incoming calls barred.
+    * //BEARERCAPABILITY_NOTAUTH// - Bearer capability not authorized.
+    * //BEARERCAPABILITY_NOTAVAIL// - Bearer capability not presently available.
+    * //SERVICE_UNAVAILABLE// - Service or option not available, unspecified.
+    * //BEARERCAPABILITY_NOTIMPL// - Bearer capability not implemented.
+    * //CHAN_NOT_IMPLEMENTED// - Channel type not implemented.
+    * //FACILITY_NOT_IMPLEMENTED// - Requested facility not implemented.
+    * //SERVICE_NOT_IMPLEMENTED// - Service or option not implemented, unspecified.
+    * //INVALID_CALL_REFERENCE// - Invalid call reference value.
+    * //INCOMPATIBLE_DESTINATION// - Incompatible destination.
+    * //INVALID_MSG_UNSPECIFIED// - Invalid message, unspecified.
+    * //MANDATORY_IE_MISSING// - Mandatory information element is missing.
+    * //MESSAGE_TYPE_NONEXIST// - Message type non-existent or not implemented.
+    * //WRONG_MESSAGE// - Message not compatible with call state or message type non-existent or not implemented.
+    * //IE_NONEXIST// - Information element / parameter non-existent or not implemented.
+    * //INVALID_IE_CONTENTS// - Invalid information element contents.
+    * //WRONG_CALL_STATE// - Message not compatible with call state.
+    * //RECOVERY_ON_TIMER_EXPIRE// - Recovery on timer expiry.
+    * //MANDATORY_IE_LENGTH_ERROR// - Parameter non-existent or not implemented - passed on (national use).
+    * //PROTOCOL_ERROR// - Protocol error, unspecified.
+    * //INTERWORKING// - Inter working, unspecified.
+    * //ORIGINATOR_CANCEL// - Originator cancel.
+    * //CRASH// - System crash.
+    * //SYSTEM_SHUTDOWN// - System shutdown.
+    * //LOSE_RACE// - Lose race.
+    * //MANAGER_REQUEST// - Manager request.
+    * //BLIND_TRANSFER// - Blind transfer.
+    * //ATTENDED_TRANSFER// - Attended transfer.
+    * //ALLOTTED_TIMEOUT// - Allotted timeout expired.
+    * //USER_CHALLENGE// - User authentication challenge.
+    * //MEDIA_TIMEOUT// - Media timeout.
+    * //PICKED_OFF// - Picked off.
+    * //USER_NOT_REGISTERED// - User not registered.
+    * //PROGRESS_TIMEOUT// - Progress timeout expired.