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

[Danny Nicholas]

Select * from cdr where duration < 5 and (calldate=> date1 and calldate <= date2)

 

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:16 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: [asterisk-users] MySQL Query : Calls Answered for < 5 sec

 

Hello,

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.


Thank you in advance.

Regards,
Sans

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