[asterisk-users] MySQL Query : Calls Answered for < 5 sec
rscl.mumbai at gmail.com
Fri Sep 14 11:45:14 CDT 2012
I need a list of calls Answered and Disconnected in less than 5 sec.
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:
>> 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...
> --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:
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the asterisk-users