@Raj 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 (राज माथुर) < r...@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; > > Regards, > > -- Raj > -- > Raj Mathur || r...@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: > http://www.asterisk.org/hello > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users