Comms CDR - Revision history

Webmaster: /* Supplemental CDR Fields */

2016-08-31T12:44:14Z

Supplemental CDR Fields

← Older revision		Revision as of 12:44, 31 August 2016
Line 92:		Line 92:
	== Supplemental CDR Fields ==		== Supplemental CDR Fields ==

-	Since version 2.5-e a supplemental table for CDR information exists. The cdr_more table uses name/value pairs and matches the '''uniqueid''' value of the parent CDR record: '''uniqueid''', '''fname''', '''fvalue'''.	+	Since version 2.5-e a supplemental table for CDR information exists. The '''cdr_more''' table uses name/value pairs and matches the '''uniqueid''' value of the parent CDR record: '''uniqueid''', '''fname''', '''fvalue'''.

	{\| class="wikitable" style="width: 100%; background-color:#ffffcc; text-align:left;"		{\| class="wikitable" style="width: 100%; background-color:#ffffcc; text-align:left;"

Webmaster at 12:43, 31 August 2016

2016-08-31T12:43:48Z

← Older revision		Revision as of 12:43, 31 August 2016
Line 87:		Line 87:
	\| Peer IP		\| Peer IP
	\| ipaddr		\| ipaddr
-	\| The IP address of the peer if available.	+	\| The IP address of the peer if available. This has been deprecated (as of version 2.5-e) in the cdr table and is now collected in the cdr_more table.
	\|}		\|}
		+
		+	== Supplemental CDR Fields ==
		+
		+	Since version 2.5-e a supplemental table for CDR information exists. The cdr_more table uses name/value pairs and matches the '''uniqueid''' value of the parent CDR record: '''uniqueid''', '''fname''', '''fvalue'''.
		+
		+	{\| class="wikitable" style="width: 100%; background-color:#ffffcc; text-align:left;"
		+	\|-
		+	!Name (fname)
		+	!Description
		+	\|-
		+	\| ipaddr
		+	\| The IP address of the SIP peer, if available.
		+	\|-
		+	\| recfile
		+	\| The call recording file locator.
		+	\|-
		+	\| origdid
		+	\| The original DID/DDI that was dialed, if available.
		+	\|}
		+

	Please refer to the latest installed cdr-db.sql schema file in /usr/local/comms/install for details on data types and indices.		Please refer to the latest installed cdr-db.sql schema file in /usr/local/comms/install for details on data types and indices.

Webmaster at 15:16, 21 July 2016

2016-07-21T15:16:22Z

← Older revision		Revision as of 15:16, 21 July 2016
Line 1:		Line 1:
-	The comms CDR database collects call detail records for all calls placed to, or from the switches. It can either reside on the same physical server as the configuration database, or in a separate server/cluster. Per default comms will not collect unanswered calls. Please refer to the switch configuration cdr.conf file [general] section and set unanswered = yes if you want to collect these calls. Please be aware that this can cause a substantial increase in collected records.	+	The comms CDR database collects call detail records for all calls placed to, or from the switches. It can either reside on the same physical server as the configuration database, or in a separate server/cluster. Per default comms will not collect unanswered calls. Please refer to the switch configuration cdr.conf file [general] section and set unanswered = yes if you want to collect these calls. Please be aware that this can cause a substantial increase in collected records. See also [[Comms_Administrator_Interface#System Maintenance\|CDR Maintenance]].

	== CDR Fields ==		== CDR Fields ==

Webmaster at 14:12, 19 April 2016

2016-04-19T14:12:48Z

← Older revision		Revision as of 14:12, 19 April 2016
Line 5:		Line 5:
	{\| class="wikitable" style="width: 100%; background-color:#ffffcc; text-align:left;"		{\| class="wikitable" style="width: 100%; background-color:#ffffcc; text-align:left;"
	\|-		\|-
-	!Name	+	!Viewer Name
-	!Database Field	+	!Database Field Name
	!Description		!Description
	\|-		\|-

Webmaster at 14:12, 19 April 2016

2016-04-19T14:12:20Z

← Older revision		Revision as of 14:12, 19 April 2016
Line 3:		Line 3:
	== CDR Fields ==		== CDR Fields ==

-	{\| class="wikitable" style="background-color:#ffffcc; text-align:left;"	+	{\| class="wikitable" style="width: 100%; background-color:#ffffcc; text-align:left;"
	\|-		\|-
	!Name		!Name

Webmaster at 14:11, 19 April 2016

2016-04-19T14:11:57Z

← Older revision		Revision as of 14:11, 19 April 2016
Line 63:		Line 63:
	\| Account Code		\| Account Code
	\| accountcode		\| accountcode
-	\| The account code for the call placing channel.	+	\| The account code for the call placing channel. Format: [enterprise ID]-[extension], [retail ID] or just [enterprise ID].
	\|-		\|-
	\| Call ID		\| Call ID
Line 71:		Line 71:
	\| User Field		\| User Field
	\| userfield		\| userfield
-	\| The user field for the receiving channel - See also account code.	+	\| The user field for the receiving channel - See also account code. Format: [enterprise ID]-[extension], [retail ID] or just [enterprise ID].
	\|-		\|-
	\| Pilot/BTN		\| Pilot/BTN

Webmaster at 14:09, 19 April 2016

2016-04-19T14:09:49Z

← Older revision		Revision as of 14:09, 19 April 2016
Line 5:		Line 5:
	{\| class="wikitable" style="background-color:#ffffcc; text-align:left;"		{\| class="wikitable" style="background-color:#ffffcc; text-align:left;"
	\|-		\|-
-	!Field	+	!Name
		+	!Database Field
	!Description		!Description
	\|-		\|-
		+	\| Date and Time
	\| calldate		\| calldate
	\| Start Date and Time of the call.		\| Start Date and Time of the call.
	\|-		\|-
		+	\| Caller ID
	\| clid		\| clid
	\| The caller ID for the call.		\| The caller ID for the call.
	\|-		\|-
		+	\| Source
	\| src		\| src
	\| The source extension for the call.		\| The source extension for the call.
	\|-		\|-
	\| dst		\| dst
		+	\| Destination
	\| The destination of the call.		\| The destination of the call.
	\|-		\|-
		+	\| Context
	\| dcontext		\| dcontext
	\| The destination context. Usually this would be 'inside', 'incoming' or 'outgoing'.		\| The destination context. Usually this would be 'inside', 'incoming' or 'outgoing'.
	\|-		\|-
		+	\| Source Channel
	\| channel		\| channel
	\| The channel of the call.		\| The channel of the call.
	\|-		\|-
		+	\| Destination Channel
	\| dstchannel		\| dstchannel
	\| The destination channel of the call.		\| The destination channel of the call.
	\|-		\|-
		+	\| Application
	\| lastapp		\| lastapp
	\| The last Asterisk application that was called.		\| The last Asterisk application that was called.
	\|-		\|-
		+	\| Application Data
	\| lastdata		\| lastdata
	\| The last Asterisk application data that was passed.		\| The last Asterisk application data that was passed.
	\|-		\|-
		+	\| Duration
	\| duration		\| duration
	\| The duration of the call including call set up.		\| The duration of the call including call set up.
	\|-		\|-
		+	\| Billing Duration
	\| billsec		\| billsec
	\| The billing duration of the call. Relevant duration for billing purposes.		\| The billing duration of the call. Relevant duration for billing purposes.
	\|-		\|-
		+	\| Call Disposition
	\| disposition		\| disposition
	\| The call disposition: ANSWERED, NO ANSWER, CONGESTION, FAILED, BUSY.		\| The call disposition: ANSWERED, NO ANSWER, CONGESTION, FAILED, BUSY.
	\|-		\|-
		+	\| (not shown)
	\| amaflags		\| amaflags
	\| The AMA flags (unused in comms)		\| The AMA flags (unused in comms)
	\|-		\|-
		+	\| Account Code
	\| accountcode		\| accountcode
	\| The account code for the call placing channel.		\| The account code for the call placing channel.
	\|-		\|-
		+	\| Call ID
	\| uniqueid		\| uniqueid
	\| The unique ID for the call as generated by Asterisk. Will also include the switch ID.		\| The unique ID for the call as generated by Asterisk. Will also include the switch ID.
	\|-		\|-
		+	\| User Field
	\| userfield		\| userfield
	\| The user field for the receiving channel - See also account code.		\| The user field for the receiving channel - See also account code.
	\|-		\|-
		+	\| Pilot/BTN
	\| pilot		\| pilot
	\| The comms Pilot/BTN as set by the application.		\| The comms Pilot/BTN as set by the application.
	\|-		\|-
		+	\| Comms Application
	\| commsapp		\| commsapp
	\| The last comms application with parameters.		\| The last comms application with parameters.
	\|-		\|-
		+	\| (not shown)
	\| ID		\| ID
	\| The unique database ID for the call.		\| The unique database ID for the call.
	\|-		\|-
		+	\| Peer IP
	\| ipaddr		\| ipaddr
	\| The IP address of the peer if available.		\| The IP address of the peer if available.

Webmaster at 14:05, 19 April 2016

2016-04-19T14:05:49Z

← Older revision		Revision as of 14:05, 19 April 2016
Line 66:		Line 66:
	\|-		\|-
	\| ipaddr		\| ipaddr
-	\| The IP address of the peer if available	+	\| The IP address of the peer if available.
	\|}		\|}

	Please refer to the latest installed cdr-db.sql schema file in /usr/local/comms/install for details on data types and indices.		Please refer to the latest installed cdr-db.sql schema file in /usr/local/comms/install for details on data types and indices.

Webmaster at 14:05, 19 April 2016

2016-04-19T14:05:36Z

← Older revision		Revision as of 14:05, 19 April 2016
Line 45:		Line 45:
	\|-		\|-
	\| amaflags		\| amaflags
-	\| The AMA flags (unused in comms)/	+	\| The AMA flags (unused in comms)
	\|-		\|-
	\| accountcode		\| accountcode

Webmaster at 14:05, 19 April 2016

2016-04-19T14:05:19Z

← Older revision		Revision as of 14:05, 19 April 2016
Line 2:		Line 2:

	== CDR Fields ==		== CDR Fields ==
		+
		+	{\| class="wikitable" style="background-color:#ffffcc; text-align:left;"
		+	\|-
		+	!Field
		+	!Description
		+	\|-
		+	\| calldate
		+	\| Start Date and Time of the call.
		+	\|-
		+	\| clid
		+	\| The caller ID for the call.
		+	\|-
		+	\| src
		+	\| The source extension for the call.
		+	\|-
		+	\| dst
		+	\| The destination of the call.
		+	\|-
		+	\| dcontext
		+	\| The destination context. Usually this would be 'inside', 'incoming' or 'outgoing'.
		+	\|-
		+	\| channel
		+	\| The channel of the call.
		+	\|-
		+	\| dstchannel
		+	\| The destination channel of the call.
		+	\|-
		+	\| lastapp
		+	\| The last Asterisk application that was called.
		+	\|-
		+	\| lastdata
		+	\| The last Asterisk application data that was passed.
		+	\|-
		+	\| duration
		+	\| The duration of the call including call set up.
		+	\|-
		+	\| billsec
		+	\| The billing duration of the call. Relevant duration for billing purposes.
		+	\|-
		+	\| disposition
		+	\| The call disposition: ANSWERED, NO ANSWER, CONGESTION, FAILED, BUSY.
		+	\|-
		+	\| amaflags
		+	\| The AMA flags (unused in comms)/
		+	\|-
		+	\| accountcode
		+	\| The account code for the call placing channel.
		+	\|-
		+	\| uniqueid
		+	\| The unique ID for the call as generated by Asterisk. Will also include the switch ID.
		+	\|-
		+	\| userfield
		+	\| The user field for the receiving channel - See also account code.
		+	\|-
		+	\| pilot
		+	\| The comms Pilot/BTN as set by the application.
		+	\|-
		+	\| commsapp
		+	\| The last comms application with parameters.
		+	\|-
		+	\| ID
		+	\| The unique database ID for the call.
		+	\|-
		+	\| ipaddr
		+	\| The IP address of the peer if available
		+	\|}
		+
		+	Please refer to the latest installed cdr-db.sql schema file in /usr/local/comms/install for details on data types and indices.