Telephony history

The page Telephony→History shows all the calls done by the Comms Mundi telephony module. It can be used also as debug, since it shows all the steps done by a call.

In Comms Mundi there is a limitation on the number of rows store internally, to avoid this limit, you can export the telephony call logs to an external database or to an CSV file.

In the page Telephony→History, at the bottom of the page by pressing in the csv icon the system will prompt you a menu to download the csv file.
You can select the columns to export. In order to select the variables to export do:

• 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

This action can take a while according to the size of calls to export.

In the page Telephony→History [CDR Backend] you can export call logs automatically to a remote database using a ODBC connector.

To configure the export do:

• check Enable CDR backend
• Set the variables to 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
• set the ODBC connector
• set the table
  • by pressing create table will create the table on the remote database
• click update

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.

• 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

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.