User Activity - Revision history

Admin at 16:29, 1 December 2023

2023-12-01T16:29:12Z

← Older revision		Revision as of 16:29, 1 December 2023
Line 39:		Line 39:

	* Voicemail - Qty : numbers of calls landing in the voicemail box (wherelanded)		* Voicemail - Qty : numbers of calls landing in the voicemail box (wherelanded)

			* Total Talk - Duration : sum of the answered time for inbound and outbound calls

Admin at 16:27, 1 December 2023

2023-12-01T16:27:11Z

← Older revision		Revision as of 16:27, 1 December 2023
Line 21:		Line 21:
	* Outbound SMS - Qty : number of entries for the extension (sm_realsrc) with the OUT direction and response "DELIVERED"		* Outbound SMS - Qty : number of entries for the extension (sm_realsrc) with the OUT direction and response "DELIVERED"

	The Inbound calls are counted using the sc_simplecdr table. There is a very big difference about the disposition in the cdr table and the disposition in the sc_simplecdr. For the cdr, a call is answered when it is answered from a SIP point of view. IN the sc_simplecdr a call is answered when it is bridged with another leg. So in short, a queue playing MOH to the caller is answered for the cdr, but not for the sc_simplecdr.		The Inbound answered calls are counted using the sc_simplecdr table. There is a very big difference about the disposition in the cdr table and the disposition in the sc_simplecdr. For the cdr, a call is answered when it is answered from a SIP point of view. IN the sc_simplecdr a call is answered when it is bridged with another leg. So in short, a queue playing MOH to the caller is answered for the cdr, but not for the sc_simplecdr.

			* Inbound Answered - Qty : number of calls received by the extension (sc_whoanswered) having disposition=ANSWERED and direction IN
			* Inbound Answered - Duration : sum of the time talking with the extension (sc_duration)
			* Inbound Answered - Avg Duration : average duration for an answered call (avg of sc_duration)

			Other type of disposition are counted using the cdr table

			* Inbound Busy - Qty : number of calls received by the extension (wherelanded) with the userfield containing the inbound label, disposition Busy and no other leg of the same call, based on linkedid has been answered
			* Inbound No Answer - Qty : number of calls received by the extension (wherelanded) with the userfield containing the inbound label, disposition No Answer and no other leg of the same call, based on linkedid has been answered
			* Inbound Failed - Qty : number of calls received by the extension (wherelanded) with the userfield containing the inbound label, disposition Failed and no other leg of the same call, based on linkedid has been answered
			* Inbound Congestion - Qty : number of calls received by the extension (wherelanded) with the userfield containing the inbound label, disposition Congestion and no other leg of the same call, based on linkedid has been answered

			The queue statistics are counted from the queue_log table

			* Queue transfered to - Qty : numbers of calls transfered from a queue to the extension using BLIND or ATTENDED transfer

			* Voicemail - Qty : numbers of calls landing in the voicemail box (wherelanded)

Admin: Created page with "== User Activity == In this statistics you can get some informations about the extension activities. The data are computed based on the cdr and sc_simplecdr table. An answered call is a call from cdr table having disposition=ANSWERED and userfield containing [outbound] string. * Outbound Answered - Qty : number of calls dialed by the extension (realsrc) and answered by the remote party * Outbound Answered - Duration : sum of the time talking with the remote party (su..."

2023-12-01T15:57:02Z

Created page with "== User Activity == In this statistics you can get some informations about the extension activities. The data are computed based on the cdr and sc_simplecdr table. An answered call is a call from cdr table having disposition=ANSWERED and userfield containing [outbound] string. * Outbound Answered - Qty : number of calls dialed by the extension (realsrc) and answered by the remote party * Outbound Answered - Duration : sum of the time talking with the remote party (su..."

New page

== User Activity ==

In this statistics you can get some informations about the extension activities. The data are computed based on the cdr and sc_simplecdr table.

An answered call is a call from cdr table having disposition=ANSWERED and userfield containing [outbound] string.

* Outbound Answered - Qty : number of calls dialed by the extension (realsrc) and answered by the remote party
* Outbound Answered - Duration : sum of the time talking with the remote party (sum of billsec)
* Outbound Answered - Avg Duration : average duration for an answered call (avg of billsec)
* Outbound Answered - Cost : sum of costs associated to selected calls (sum of cc_costs)

* Outbound Busy - Qty : number of calls dialed by the extension (realsrc) and reported Busy from the remote party
* Outbound No Answer - Qty : number of calls dialed by the extension (realsrc) and reported No Answer from the remote party
* Outbound Failed - Qty : number of calls dialed by the extension (realsrc) and reported Failed from the remote party
* Outbound Congestion - Qty : number of calls dialed by the extension (realsrc) and reported Congestion from the remote party

* Outbound TOTAL - Qty : sum of all previous Qty of calls

The SMS are counted from the sm_smslogs table

* Outbound SMS - Qty : number of entries for the extension (sm_realsrc) with the OUT direction and response "DELIVERED"

The Inbound calls are counted using the sc_simplecdr table. There is a very big difference about the disposition in the cdr table and the disposition in the sc_simplecdr. For the cdr, a call is answered when it is answered from a SIP point of view. IN the sc_simplecdr a call is answered when it is bridged with another leg. So in short, a queue playing MOH to the caller is answered for the cdr, but not for the sc_simplecdr.