[asterisk-users] MySQL Query : Calls Answered for < 5 sec
rscl.mumbai at gmail.com
Fri Sep 14 11:33:42 CDT 2012
I tried your query and variation by using replacing duration with billsec.
In both cases, I get results including disposition "NO ANSWER"
On Fri, Sep 14, 2012 at 9:58 PM, Raj Mathur (राज माथुर) <
raju at linux-delhi.org> wrote:
> 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
> 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
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> New to Asterisk? Join us for a live introductory webinar every Thurs:
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the asterisk-users