[asterisk-users] MySQL Query : Calls Answered for < 5 sec

[Danny Nicholas]

Change to this:

select * from cdr
where calldate >= '2012-09-01' and calldate < '2012-09-08'
and duration < 5 and disposition<>’NO ANSWER’;



 

From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of RSCL Mumbai
Sent: Friday, September 14, 2012 11:34 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [asterisk-users] MySQL Query : Calls Answered for < 5 sec

 

@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 (राज माथुर) <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;

Regards,

-- 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:
               http://www.asterisk.org/hello

asterisk-users mailing list
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20120914/fdb5b55c/attachment.htm>