API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 17th, 2018
449
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 4.58 KB | None | 0 0
raw download clone embed print report
  1. ameyodb=# 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 20;
  2. call_id | campaign_id | phone | dialing_comments | system_disposition | hangup
  3. _cause_code | date_added
  4. ---------------------------+-------------+---------------+------------------------------------------------------------------------------+-----------------------+-------
  5. ------------+-------------------------
  6. d581-59e426de-vcall-83269 | 10 | 8613551775702 | ["Party.could.not.be.connected.Reason","8613551775702","No user responding"] | BUSY | 18
  7. | 2018-01-17 18:54:10.672
  8. d581-59e426de-vcall-83268 | 10 | 8613551775702 | ["Party.could.not.be.connected.Reason","8613551775702","Request Terminated"] | PROVIDER_TEMP_FAILURE | 487
  9. | 2018-01-17 18:53:33.976
  10. d581-59e426de-vcall-83267 | 10 | 8618229050080 | ["Party.could.not.be.connected.Reason","8618229050080","No user responding"] | BUSY | 18
  11. | 2018-01-17 18:53:29.618
  12. d581-59e426de-vcall-83266 | 10 | 8615874122248 | ["Party.could.not.be.connected.Reason","8615874122248","No user responding"] | BUSY | 18
  13. | 2018-01-17 18:53:29.615
  14. d581-59e426de-vcall-83265 | 2 | 639176623471 | ["Party.could.not.be.connected.Reason","639176623471","No user responding"] | BUSY | 18
  15. | 2018-01-17 18:52:46.229
  16. d581-59e426de-vcall-83264 | 10 | 8615266666648 | ["Party.could.not.be.connected.Reason","8615266666648","No user responding"] | BUSY | 18
  17. | 2018-01-17 17:50:02.715
  18. d581-59e426de-vcall-83263 | 10 | 8615228887762 | ["Party.could.not.be.connected.Reason","8615228887762","No user responding"] | BUSY | 18
  19. | 2018-01-17 17:50:02.711
  20. d581-59e426de-vcall-83262 | 2 | 639176623471 | ["Party.could.not.be.connected.Reason","639176623471","No user responding"] | BUSY | 18
  21. | 2018-01-17 17:37:27.592
  22. d581-59e426de-vcall-83261 | 2 | 639258529733 | Customer or contact found in DNC | ATTEMPT_FAILED |
  23. | 2018-01-17 17:37:08.579
  24. d581-59e426de-vcall-83260 | 2 | 639176623471 | ["Party.could.not.be.connected.Reason","639176623471","No user responding"] | BUSY | 18
  25. | 2018-01-17 17:36:08.522
  26. d581-59e426de-vcall-83259 | 10 | 8613483520520 | ["Party.could.not.be.connected.Reason","8613483520520","No user responding"] | BUSY | 18
  27. | 2018-01-17 17:26:13.324
  28. d581-59e426de-vcall-83258 | 10 | 8613704542004 | ["Party.could.not.be.connected.Reason","8613704542004","No user responding"] | BUSY | 18
  29. | 2018-01-17 17:26:13.322
  30. d581-59e426de-vcall-83257 | 10 | 8615045158213 | ["Party.could.not.be.connected.Reason","8615045158213","No user responding"] | BUSY | 18
  31. | 2018-01-17 17:18:34.984
  32. d581-59e426de-vcall-83256 | 10 | 8613906310700 | ["Party.could.not.be.connected.Reason","8613906310700","No user responding"] | BUSY | 18
  33. | 2018-01-17 17:18:34.982
  34. d581-59e426de-vcall-83255 | 10 | 8618607209966 | ["Party.could.not.be.connected.Reason","8618607209966","No user responding"] | BUSY | 18
  35. | 2018-01-17 17:18:10.966
  36. d581-59e426de-vcall-83254 | 10 | 8615223242801 | ["Party.could.not.be.connected.Reason","8615223242801","No user responding"] | BUSY | 18
  37. | 2018-01-17 17:18:10.965
  38. d581-59e426de-vcall-83253 | 10 | 8615878784188 | ["Party.could.not.be.connected.Reason","8615878784188","No user responding"] | BUSY | 18
  39. | 2018-01-17 17:17:46.946
  40. d581-59e426de-vcall-83252 | 10 | 8613117622352 | ["Party.could.not.be.connected.Reason","8613117622352","No user responding"] | BUSY | 18
  41. | 2018-01-17 17:17:46.944
  42. d581-59e426de-vcall-83251 | 10 | 8613568533333 | ["Party.could.not.be.connected.Reason","8613568533333","No user responding"] | BUSY | 18
  43. | 2018-01-17 17:17:22.926
  44. d581-59e426de-vcall-83250 | 10 | 8613647523351 | ["Party.could.not.be.connected.Reason","8613647523351","No user responding"] | BUSY | 18
  45. --More--
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!