[asterisk-users] MySQL Query : Calls Answered for < 5 sec
Raj Mathur ( राज माथुर )
raju at linux-delhi.org
Fri Sep 14 11:28:57 CDT 2012
On Friday 14 Sep 2012, RSCL Mumbai wrote:
> I am trying to construct MySQL query(s) to get a list of calls which
> lasted for less than 5 seconds between a given date range.
> Any help is appreciated.
On the CDR database, to get all calls that lasted < 5 seconds between
2012-09-01 and 2012-09-07 (inclusive), the MySQL query would be:
select * from cdr
where calldate >= '2012-09-01' and calldate < '2012-09-08'
and duration < 5;
Raj Mathur || raju at kandalaya.org || GPG:
http://otheronepercent.blogspot.com || http://kandalaya.org || CC68
It is the mind that moves || http://schizoid.in || D17F
More information about the asterisk-users