asterisk users - Sep 2012 - 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/c00422bd/attachment.htm>

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>

question worth asking in mysql user list then here !!

Regards,
Mitul Limbani,
Chief Architech & Founder,
Enterux Solutions Pvt. Ltd.
110 Reena Complex, Opp. Nathani Steel,
Vidyavihar (W), Mumbai - 400 086. India
http://www.enterux.com/
http://www.entvoice.com/
email: mitul at enterux.in
DID: +91-22-71967121
Cell: +91-9820332422




On Fri, Sep 14, 2012 at 9:46 PM, RSCL Mumbai <rscl.mumbai at gmail.com>
wrote:
> 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
>
> --
> _____________________________________________________________________
> -- 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/6add818a/attachment.htm>

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

The following query gives me calls with disposition "NO ANSWER"



On Fri, Sep 14, 2012 at 9:50 PM, Danny Nicholas <danny at debsinc.com>
wrote:
> 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****
>
> --
> _____________________________________________________________________
> -- 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/50adf1fa/attachment.htm>