Dbabo: Created page with " == voipstats database == === Description of table cdr === {| class="wikitable sortable" |- ! field !! type !! example !! description |- |calldate || timestamp without time..."

2016-06-23T14:59:54Z

Created page with " == voipstats database == === Description of table cdr === {| class="wikitable sortable" |- ! field !! type !! example !! description |- |calldate || timestamp without time..."

New page

== voipstats database ==

=== Description of table cdr ===

{| class="wikitable sortable"
|-
! field !! type !! example !! description
|-
|calldate || timestamp without time zone || 2010-10-26 12:00:00 || The start time of the call
|-
|clid || character varying(80) || "Big Bird" <12565551212> || The full caller ID, including the name, of the calling party.
|-
|src || character varying(80) || 12565551212 || The calling party’s caller ID number
|-
|dst || character varying(80) || 102 || The destination extension for the call
|-
|dcontext || character varying(80) || SER_Asterisk || The destination extension for the call.
|-
|channel || character varying(80) || SIP/kamailio-a1bc23ef || The calling party’s channel.
|-
|dstchannel || character varying(80) || SIP/102-a1bc23e7 || The called party’s channel.
|-
|lastapp || character varying(80) || Dial || The last dialplan application that was executed.
|-
|lastdata || character varying(80) || SIP/102,30,tT || The arguments passed to the lastapp.
|-
|duration || integer || 195 || The number of seconds between the calldate and endcalldate times for the call.
|-
|billsec || integer || 180 || The number of seconds between the answer and endcalldate times for the call.
|-
|disposition || character varying(45) || ANSWERED || An indication of what happened to the call. This may be NO ANSWER, FAILED, BUSY, ANSWERED, or UNKNOWN.
|-
|amaflags || integer || || The Automatic Message Accounting (AMA) flag associated with this call. (not used)
|-
|accountcode || character varying(20) || || An account ID.(not used)
|-
|userfield || character varying(255) || || A general-purpose user field. (not used)
|-
|fallback || character varying(50) || 1 || Indication if this call fallback (1 - true ; 0 or empty - false)
|-
|totalrtp1in || integer || 3000 || Total of RTP packets incomming at calling party
|-
|totalrtp1out || integer || 4000 || Total of RTP packets outgoing at calling party
|-
|lostrtp1 || integer || 20 || Number of lost rtp packets at calling party
|-
|tlatency1 || integer || 2 || Maximun latency at calling party
|-
|tjitter1 || integer || 1 || Maximun jitter at calling party
|-
|alatency1 || integer || 2 || Average latency at calling party
|-
|ajitter1 || integer || 1 || Average jitter at calling party
|-
|codec1 || character varying(50) || GSM || Audio/Video Codec at calling party
|-
|signalling1 || character varying(50) || SIP || Signalling protocol at calling party
|-
|callerid1 || character varying(50) || 100 || Callerid at calling party
|-
|ip1 || character varying(50) || 10.1.0.100 || IP at calling party
|-
|totalrtp2in || integer || 3000 || Total of RTP packets incomming at called party
|-
|totalrtp2out || integer || 4000 || Total of RTP packets outgoing at called party
|-
|lostrtp2 || integer || 20 || Number of lost rtp packets at called party
|-
|tlatency2 || integer || 2 || Maximun latency at called party
|-
|tjitter2 || integer || 1 || Maximun jitter at called party
|-
|alatency2 || integer || 2 || Average latency at called party
|-
|ajitter2 || integer || 1 || Average jitter at called party
|-
|codec2 || character varying(50) || GSM || Audio/Video Codec at called party
|-
|signalling2 || character varying(50) || SIP || Signalling protocol at called party
|-
|callerid2 || character varying(50) || 102 || Callerid at called party
|-
|ip2 || character varying(50) || 10.1.0.103 || IP at called party
|-
|srcipb || character varying(80) || 12565551212 || The calling party’s caller ID number (this value is more accurate that src)
|-
|dstipb || character varying(80) || 102 || The destination extension for the call (this value is more accurate that dst)
|-
|transfered || integer || 1 || Indication if this call was transfered (1 - true ; 0 or empty - false)
|-
|monitorfile || character varying(100) || /home1/_voip/monitoring/2011-07-15-21:02:00_ipmtel007_ipmtel027_1310760120.0.MP3 || Temporary file path of call recording
|-
|uniqueid || character varying(24) || 1425102718.0 || Unique Channel Identifier
|-
|utilizador || character varying(255) || |10014 || Identify the users presents on call. Sintaxe uidnumber of origin user '|' uidnumber of destination user
|-
|endcalldate || timestamp without time zone || 2010-10-26 12:00:00 || The end time of the call
|-
|functionstamp || character varying(80) || 1289906050.39986-QUEUE_3 || Unique Identifier of the function used
|-
|lastdst || character varying(80) || 102 || The last called party.
|-
|route || character varying(80) || 0801_VipVoz || Name of the route used or name of the funtion used
|-
|direction || integer || 1 || Direction of the call (not used)
|-
|uniqueid2 || character varying(80) || 1425102718.0 || Unique Call Identifier
|-
|enum || character varying(80) || 1 || Indication if this call use ENUM Lookup (1 - true ; 0 or empty - false)
|}

VoIP Statistics - Revision history

Dbabo: Created page with " == voipstats database == === Description of table cdr === {| class="wikitable sortable" |- ! field !! type !! example !! description |- |calldate || timestamp without time..."