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

[RSCL Mumbai]

I need a list of calls Answered and Disconnected in less than 5 sec.

Thx



On Fri, Sep 14, 2012 at 10:07 PM, Warren Selby <wcselby at selbytech.com>wrote:

> On Fri, Sep 14, 2012 at 11:33 AM, RSCL Mumbai <rscl.mumbai at gmail.com>wrote:
>
>> @Raj
>>
>> I tried your query and variation by using replacing duration with billsec.
>> In both cases, I get results including disposition "NO ANSWER"
>>
>
>
> If you don't want the "NO ANSWER" disposition, add an AND NOT DISPOSITION
> = 'NO ANSWER' to your query.  This is all pretty basic SQL Query writing,
> not specific to asterisk...
>
> --
> Thanks,
> --Warren Selby, dCAP
> http://www.SelbyTech.com <http://www.selbytech.com>
>
>
> --
> _____________________________________________________________________
> -- 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/4a617a80/attachment.htm>