[asterisk-users] CDR extract call numbers on interval on unique callers

[John Runyon]

https://dev.mysql.com/doc/refman/8.0/en/group-by-functions.html#function_count-distinct

Use something like count(distinct src) instead of count(*)

On Tue, Nov 12, 2019, 07:35 Andre Gronwald <andregronwald78 at gmail.com>
wrote:

> hi,
>
> we want to extract the information when the most callers are entering
> our phone system based on an interval of 15 minutes. this is quite
> simple (although not perfect) with
> select calldate, count(*) as anzahl from cdr where calldate >
> '2019-10-12' group by unix_timestamp(calldate) DIV 900 having ;
>
> Unfortunately we have lots of callers who calls multiple times when they
> are forwarded to a queue instead of being answered by a human
> immediately. But to know when we need more people I want to count same
> caller-ids within an interval as one call.
>
> Any ideas how to do this?
>
> kind regards,
> andre
>
> --
> _____________________________________________________________________
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
>
> Check out the new Asterisk community forum at:
> https://community.asterisk.org/
>
> New to Asterisk? Start here:
>       https://wiki.asterisk.org/wiki/display/AST/Getting+Started
>
> 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/20191112/2fb50402/attachment.html>