[asterisk-users] CDR extract call numbers on interval on unique callers
john at simplynuc.com
Tue Nov 12 07:48:07 CST 2019
Use something like count(distinct src) instead of count(*)
On Tue, Nov 12, 2019, 07:35 Andre Gronwald <andregronwald78 at gmail.com>
> 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,
> -- Bandwidth and Colocation Provided by http://www.api-digital.com --
> Check out the new Asterisk community forum at:
> New to Asterisk? Start here:
> asterisk-users mailing list
> To UNSUBSCRIBE or update options visit:
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the asterisk-users