Output of the API LISTING task
Revision as of 14:31, 19 May 2023 by Petr.halounek (talk | contribs)
Examples
zero results
curl -X POST -k --cookie "PHPSESSID-voipmonitor=2ffd2fb6bef76dfa6f2ff3630e86cca39c8b93ee4761b2a45f9f804e321d1736" "http://192.168.88.156/voipmonitor/php/model/sql.php?task=LISTING&module=CDR&fdatefrom=2023-05-13T10:00:00&fcaller=11"
{"total":0,"results":null,"success":true,"_vm_version":250008}
Results suppressed
curl -X POST -k --cookie "PHPSESSID-voipmonitor=00d61b82469a39a21c6ce7d5a1e4129af4f3777d3cdfa81d6f652e5e807baa49" "http://192.168.88.156/voipmonitor/php/model/sql.php?task=LISTING&module=CDR&fdatefrom=2013-05-08T00:00:00&fcaller=11&suppress_results=1"
{"total":"1","success":true,"_vm_version":250008}
One result
curl -X POST -k --cookie "PHPSESSID-voipmonitor=2ffd2fb6bef76dfa6f2ff3630e86cca39c8b93ee4761b2a45f9f804e321d1736" "http://192.168.88.156/voipmonitor/php/model/sql.php?task=LISTING&module=CDR&fdatefrom=2023-05-12T10:00:00&fcaller=11"
Because the response for single CDR is json string that contains over 16k of chars, here is result after passing the string to json_decode fce with use of var_dump for printing its contents splited by fields:
(
[total] => 1
[deferTotal] =>
[results] => Array
(
[0] => stdClass Object
(
[ID] => 55
[calldate] => 2023-05-12 16:33:17
[callend] => 2023-05-12 16:50:12
[duration] => 16:55
[connect_duration] => 16:40
[progress_time] => 0
[first_rtp_time] => 0
[caller] => 11
[caller_domain] => 192.168.88.199
[caller_reverse] => 11
[callername] =>
[callername_reverse] =>
[called] => 34567654567865
[called_domain] => 192.168.88.199
[called_reverse] => 56876545676543
[sipcallerip] => 192.168.88.174
[sipcallerport] => 5060
[sipcalledip] => 192.168.88.199
[sipcalledport] => 5060
[whohanged] => callee
[bye] => 3
[lastSIPresponse_id] => 1
[lastSIPresponseNum] => 200
[reason_sip_cause] =>
[reason_sip_text_id] =>
[reason_q850_cause] =>
[reason_q850_text_id] =>
[sighup] => 0
[dscp] => 0
[a_index] => 0
[b_index] =>
[a_payload] => 8
[b_payload] =>
[a_saddr] => 192.168.88.174
[b_saddr] =>
[a_received] => 50725
[b_received] =>
[a_lost] => 0
[b_lost] =>
[a_ua_id] => 3
[b_ua_id] => 1
[a_avgjitter_mult10] => 4
[b_avgjitter_mult10] =>
[a_maxjitter] => 10
[b_maxjitter] =>
[a_sl1] => 0
[a_sl2] => 0
[a_sl3] => 0
[a_sl4] => 0
[a_sl5] => 0
[a_sl6] => 0
[a_sl7] => 0
[a_sl8] => 0
[a_sl9] => 0
[a_sl10] => 0
[a_d50] => 0
[a_d70] => 0
[a_d90] => 0
[a_d120] => 0
[a_d150] => 0
[a_d200] => 0
[a_d300] => 0
[b_sl1] =>
[b_sl2] =>
[b_sl3] =>
[b_sl4] =>
[b_sl5] =>
[b_sl6] =>
[b_sl7] =>
[b_sl8] =>
[b_sl9] =>
[b_sl10] =>
[b_d50] =>
[b_d70] =>
[b_d90] =>
[b_d120] =>
[b_d150] =>
[b_d200] =>
[b_d300] =>
[a_mos_lqo_mult10] =>
[b_mos_lqo_mult10] =>
[a_mos_f1_min_mult10] => 45
[a_mos_f2_min_mult10] => 45
[a_mos_adapt_min_mult10] => 39
[a_mos_xr_min_mult10] =>
[a_mos_silence_min_mult10] => 45
[b_mos_f1_min_mult10] =>
[b_mos_f2_min_mult10] =>
[b_mos_adapt_min_mult10] =>
[b_mos_xr_min_mult10] =>
[b_mos_silence_min_mult10] =>
[a_mos_f1_mult10] => 45
[a_mos_f2_mult10] => 45
[a_mos_adapt_mult10] => 45
[a_mos_xr_mult10] =>
[a_mos_silence_mult10] => 45
[b_mos_f1_mult10] =>
[b_mos_f2_mult10] =>
[b_mos_adapt_mult10] =>
[b_mos_xr_mult10] =>
[b_mos_silence_mult10] =>
[a_rtcp_loss] => 0
[a_rtcp_maxfr] => 0
[a_rtcp_avgfr_mult10] => 0
[a_rtcp_maxjitter] => 1
[a_rtcp_avgjitter_mult10] => 3
[a_rtcp_avgrtd_mult10] =>
[a_rtcp_maxrtd_mult10] =>
[a_rtcp_avgrtd_w] => 1
[a_rtcp_maxrtd_w] => 2
[b_rtcp_loss] =>
[b_rtcp_maxfr] =>
[b_rtcp_avgfr_mult10] =>
[b_rtcp_maxjitter] =>
[b_rtcp_avgjitter_mult10] =>
[b_rtcp_avgrtd_mult10] =>
[b_rtcp_maxrtd_mult10] =>
[b_rtcp_avgrtd_w] =>
[b_rtcp_maxrtd_w] =>
[a_last_rtp_from_end] => 0
[b_last_rtp_from_end] =>
[a_rtcp_fraclost_pktcount] => 0
[b_rtcp_fraclost_pktcount] =>
[a_rtp_ptime] => 20
[b_rtp_ptime] =>
[payload] => 8
[jitter_mult10] => 4
[mos_min_mult10] => 45
[a_mos_min_mult10] => 45
[b_mos_min_mult10] =>
[packet_loss_perc_mult1000] => 0
[a_packet_loss_perc_mult1000] => 0
[b_packet_loss_perc_mult1000] =>
[delay_sum] => 0
[a_delay_sum] => 0
[b_delay_sum] =>
[delay_avg_mult100] => 0
[a_delay_avg_mult100] => 0
[b_delay_avg_mult100] =>
[delay_cnt] => 0
[a_delay_cnt] => 0
[b_delay_cnt] =>
[rtcp_avgfr_mult10] => 0
[rtcp_avgjitter_mult10] => 3
[lost] => 0
[caller_clipping_div3] =>
[called_clipping_div3] =>
[caller_silence] =>
[called_silence] =>
[caller_silence_end] =>
[called_silence_end] =>
[response_time_100] => 28
[response_time_xxx] => 0
[max_retransmission_invite] =>
[flags] => 131072
[vlan] =>
[id_sensor] =>
[price_operator_currency_id] =>
[price_customer_currency_id] =>
[rtp_stream_used_in_another_call] => 0
[sensorname] =>
[lastSIPresponse] => 200 Ok
[a_ua] => Linphone Desktop/5.0.0 (BobisekNTB) Windows 10 Version 2009, Qt 5.15.2 LinphoneCore/5.2.0-2-g29c553987
[b_ua] => Asterisk PBX 16.28.0~dfsg-0+deb10u2
[cdr_ID] => 55
[custom_header1] =>
[fbasename] => xZZvFAX6YP
[digest_username] => 11
[match_header] =>
[GeoPosition] =>
[hold] =>
[spool_index] =>
[custom_header_1_1] =>
[custom_header_1_2] =>
[sipcallerip_country_code] =>
[sipcalledip_country_code] =>
[caller_number_country_code] =>
[called_number_country_code] =>
[sipcallerip_country] =>
[sipcalledip_country] =>
[caller_number_country] =>
[called_number_country] =>
[price_operator] =>
[price_customer] => 17000000
[a_avgjitter] => 0.4
[b_avgjitter] =>
[a_mos_lqo] =>
[b_mos_lqo] =>
[a_mos_f1_min] => 4.5
[a_mos_f2_min] => 4.5
[a_mos_adapt_min] => 3.9
[a_mos_xr_min] =>
[a_mos_silence_min] => 4.5
[b_mos_f1_min] =>
[b_mos_f2_min] =>
[b_mos_adapt_min] =>
[b_mos_xr_min] =>
[b_mos_silence_min] =>
[a_mos_f1] => 4.5
[a_mos_f2] => 4.5
[a_mos_adapt] => 4.5
[a_mos_xr] =>
[a_mos_silence] => 4.5
[b_mos_f1] =>
[b_mos_f2] =>
[b_mos_adapt] =>
[b_mos_xr] =>
[b_mos_silence] =>
[a_rtcp_avgfr] => 0
[a_rtcp_avgjitter] => 0.3
[a_rtcp_avgrtd] =>
[a_rtcp_maxrtd] =>
[b_rtcp_avgfr] =>
[b_rtcp_avgjitter] =>
[b_rtcp_avgrtd] =>
[b_rtcp_maxrtd] =>
[jitter] => 0.4
[mos_min] => 4.5
[a_mos_min] => 4.5
[b_mos_min] =>
[packet_loss_perc] => 0
[a_packet_loss_perc] => 0
[b_packet_loss_perc] =>
[delay_avg] => 0
[a_delay_avg] => 0
[b_delay_avg] =>
[rtcp_avgfr] => 0
[rtcp_avgjitter] => 0.3
[_duration] => 1015
[_connect_duration] => 1000
[_sql_calldate] => 2023-05-12 16:33:17
[calldate_userformat] => 2023-05-12 16:33:17
[calldate2] => 2023-05-12<br>16:33:17
[callend_userformat] => 2023-05-12 16:50:12
[calldate2e] => 2023-05-12<br>16:33:17<br>16:50:12
[duration2] =>
16:55 (0)<br>16:40
G.711a [caller_icon_hanged] =>
[called_icon_hanged] => <img src="images/icon/hangup8.gif"/>
[lastresponse] => 200<br>200 Ok
[callerrtp] => 192.168.88.174
[sipcaller_host] =>
[sipcaller_host_color] =>
[sipcalled_host] =>
[sipcalled_host_color] =>
[callerrtp_host] =>
[callerrtp_host_color] =>
[caller_with_domain] => 11@192.168.88.199
[called_with_domain] => 34567654567865@192.168.88.199
[sipcalleripMenu] => 192.168.88.174
[sipcalledipMenu] => 192.168.88.199
[caller2] => 11@192.168.88.199<br>callername is empty (11)<br>192.168.88.174 : 5060
Linphone Desktop/5.0.0 (BobisekNTB) Windows 10 Version 2009, Qt 5.15.2 LinphoneCore/5.2.0-2-g29c553987
[called2] => 34567654567865@192.168.88.199<img src="images/icon/hangup8.gif"/><br>192.168.88.199 : 5060<br>Asterisk PBX 16.28.0~dfsg-0+deb10u2
[sipcallerip2] => 192.168.88.174<br>
[sipcalledip2] => 192.168.88.199<br>
[ringing_time] => 15
[sipresponse] => 200 Ok
[a_codec] => G.711a
[b_codec] =>
[fbasename_orig] => xZZvFAX6YP
[menu] =>
<a>PCAP</a> <img src="images/icon/disk.png"/></div <img src="images/icon/lock.png"/></div
<a>OGG</a> <a>WAV</a> <img src="images/icon/sound.png"/></div
<img src="images/wav-player.png" width=80 height=10 cdr_id=55 panel_id=__THIS_ID__ onclick="Ext.getCmp(this.attributes.panel_id.nodeValue).doPlayWavPlayer(this.attributes.cdr_id.nodeValue,false,false,event);" onmouseover="this.style.cursor='pointer';">
[menu_pcap] =>
<a>PCAP</a> <img src="images/icon/disk.png"/></div
[menu_wav] =>
<a>OGG</a> <a>WAV</a> <img src="images/icon/sound.png"/></div
[embedplayer_indirect] =>
[callerrtp2] => 192.168.88.174
4.5|4.5|4.5|4.5|4.5
J:0.3 | no jitter
no packet loss
[calledrtp2] => N/A
[allrtpstreams] => [{"cdr_ID":"55","calldate":"2023-05-12 16:33:17","saddr":"192.168.88.174","sport":"7078","daddr":"192.168.88.199","dport":"14518","ssrc":"1744777213","received":"50725","loss":"0","firsttime":"0.806428","payload":"8","maxjitter_mult10":"90","index":"1","flags":"6","duration":"1014.23"}]
[orig_allrtpstreams] => [{"cdr_ID":"55","calldate":"2023-05-12 16:33:17","saddr":"192.168.88.174","sport":"7078","daddr":"192.168.88.199","dport":"14518","ssrc":"1744777213","received":"50725","loss":"0","firsttime":"0.806428","payload":"8","maxjitter_mult10":"90","index":"1","flags":"6","duration":"1014.23"}]
[allsiprequests] => [{"SIPrequest":"INVITE","cnt":"2"},{"SIPrequest":"ACK","cnt":"3"},{"SIPrequest":"BYE","cnt":"1"}]
[allsipresponses] => [{"SIPresponseNum":"401","SIPresponse":"401 Unauthorized"},{"SIPresponseNum":"100","SIPresponse":"100 Trying"},{"SIPresponseNum":"183","SIPresponse":"183 Session Progress"},{"SIPresponseNum":"200","SIPresponse":"200 Ok"}]
)
)
[success] => 1
[_vm_version] => 250008
)