lucindio

Select asteriskdbcdr

Jul 26th, 2020 (edited)
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.31 KB | None | 0 0
  1. SELECT
  2.       calldate,src,dst,dstchannel,(billsec/60),disposition,uniqueid
  3. FROM cdr
  4. WHERE billsec >=4
  5. AND convert(calldate, date) BETWEEN '2019-01-01' and '2019-01-10'
  6. AND src = 1000
  7. AND dstchannel REGEXP '(^.*[SIP]\/[a-zA-Z]{3})'
  8. AND  dst REGEXP '^.{3}[5-9]{1}.*' OR '^.{1}9[0-9]{8}'
  9. ORDER BY calldate;
Add Comment
Please, Sign In to add comment