select call_id, campaign_id, phone, dialing_comments, system_disposition, hangup_cause_code,  date_added from call_history where date_added > '2018-01-17 15:00:00.000' order by date_added desc limit 50;

8615883555343

ameyoctl status


      > doing dnsmgr_lookup for 'phone.plivo.com'
       > ast_get_srv: SRV lookup for '_sip._UDP.phone.plivo.com' mapped to host phone.plivo.com, port 5060
       > doing dnsmgr_lookup for 'phone.plivo.com'
       > ast_get_srv: SRV lookup for '_sip._UDP.phone.plivo.com' mapped to host phone.plivo.com, port 5060
       > doing dnsmgr_lookup for 'phone.plivo.com'
       > ast_get_srv: SRV lookup for '_sip._UDP.phone.plivo.com' mapped to host phone.plivo.com, port 5060
  == Using SIP RTP CoS mark 5
       > Channel SIP/webrtc_CRM3-00000000 was answered.
    -- Executing [calllegoriginate@from-manager-core:1] Wait("SIP/webrtc_CRM3-00000000", "3600") in new stack
  == Spawn extension (from-manager-core, dial, 0) exited non-zero on 'SIP/webrtc_CRM3-00000000'
    -- Executing [dial@from-manager-core:1] Dial("SIP/webrtc_CRM3-00000000", "SIP/639176623471@pilvo,50000,45000") in new stack
  == Using SIP RTP CoS mark 5
    -- Called 639176623471@pilvo
[Jan 17 18:53:11] WARNING[7552]: chan_sip.c:3944 retrans_pkt: Maximum retries exceeded on transmission 171c86de52a842ee78efc08853aeb49b@phone.plivo.com for seqno 102 (Critical Request) -- See doc/sip-retransmit.txt.
[Jan 17 18:53:11] WARNING[7552]: chan_sip.c:3971 retrans_pkt: Hanging up call 171c86de52a842ee78efc08853aeb49b@phone.plivo.com - no reply to our critical packet (see doc/sip-retransmit.txt).
  == Everyone is busy/congested at this time (1:0/0/1)
    -- Executing [dial@from-manager-core:2] Goto("SIP/webrtc_CRM3-00000000", "calllegwait,1") in new stack
    -- Goto (from-manager-core,calllegwait,1)
    -- Executing [calllegwait@from-manager-core:1] Wait("SIP/webrtc_CRM3-00000000", "3600") in new stack
  == Spawn extension (from-manager-core, calllegwait, 1) exited non-zero on 'SIP/webrtc_CRM3-00000000'
    -- Executing [h@from-manager-core:1] Hangup("SIP/webrtc_CRM3-00000000", "") in new stack
  == Spawn extension (from-manager-core, h, 1) exited non-zero on 'SIP/webrtc_CRM3-00000000'
  == Using SIP RTP CoS mark 5
  == Using SIP RTP CoS mark 5
  == Using SIP RTP CoS mark 5
       > Channel SIP/webrtc_CA4-00000004 was answered.
    -- Executing [calllegoriginate@from-manager-core:1] Wait("SIP/webrtc_CA4-00000004", "3600") in new stack
  == Spawn extension (from-manager-core, dial, 0) exited non-zero on 'SIP/webrtc_CA4-00000004'
    -- Executing [dial@from-manager-core:1] Dial("SIP/webrtc_CA4-00000004", "SIP/8613551775702@pilvo,45000,60000") in new stack
  == Using SIP RTP CoS mark 5
    -- Called 8613551775702@pilvo
[Jan 17 18:53:53] WARNING[7552]: chan_sip.c:3944 retrans_pkt: Maximum retries exceeded on transmission 73d0d69212c8125338aec7bc67469504@phone.plivo.com for seqno 102 (Critical Request) -- See doc/sip-retransmit.txt.
[Jan 17 18:53:53] WARNING[7552]: chan_sip.c:3971 retrans_pkt: Hanging up call 73d0d69212c8125338aec7bc67469504@phone.plivo.com - no reply to our critical packet (see doc/sip-retransmit.txt).
[Jan 17 18:53:53] WARNING[7552]: chan_sip.c:3944 retrans_pkt: Maximum retries exceeded on transmission 68b901a11e24c79e56ee48916696de0e@phone.plivo.com for seqno 102 (Critical Request) -- See doc/sip-retransmit.txt.
[Jan 17 18:53:53] WARNING[7552]: chan_sip.c:3971 retrans_pkt: Hanging up call 68b901a11e24c79e56ee48916696de0e@phone.plivo.com - no reply to our critical packet (see doc/sip-retransmit.txt).
    -- Executing [calllegwait@from-manager-core:1] Wait("SIP/pilvo-00000005", "3600") in new stack
  == Everyone is busy/congested at this time (1:0/0/1)
    -- Executing [h@from-manager-core:1] Hangup("SIP/webrtc_CA4-00000004", "") in new stack
  == Spawn extension (from-manager-core, h, 1) exited non-zero on 'SIP/webrtc_CA4-00000004'
  == Spawn extension (from-manager-core, calllegwait, 1) exited non-zero on 'SIP/pilvo-00000005'
    -- Executing [h@from-manager-core:1] Hangup("SIP/pilvo-00000005", "") in new stack
  == Spawn extension (from-manager-core, h, 1) exited non-zero on 'SIP/pilvo-00000005'
[Jan 17 18:53:59] WARNING[7552]: chan_sip.c:3944 retrans_pkt: Maximum retries exceeded on transmission 16c9dd27482eeb563714457a340fcc4c@phone.plivo.com for seqno 102 (Critical Request) -- See doc/sip-retransmit.txt.
       > doing dnsmgr_lookup for 'phone.plivo.com'
       > ast_get_srv: SRV lookup for '_sip._UDP.phone.plivo.com' mapped to host phone.plivo.com, port 5060
  == Using SIP RTP CoS mark 5
       > Channel SIP/webrtc_CA4-00000006 was answered.
    -- Executing [calllegoriginate@from-manager-core:1] Wait("SIP/webrtc_CA4-00000006", "3600") in new stack
  == Spawn extension (from-manager-core, dial, 0) exited non-zero on 'SIP/webrtc_CA4-00000006'
    -- Executing [dial@from-manager-core:1] Dial("SIP/webrtc_CA4-00000006", "SIP/8613551775702@pilvo,45000,60000") in new stack
  == Using SIP RTP CoS mark 5
    -- Called 8613551775702@pilvo

select * from call_history limit 1 offset (select count(*) from call_history)-1;