[asterisk-users] CDR extract call numbers on interval on unique callers
andregronwald78 at gmail.com
Tue Nov 12 07:33:52 CST 2019
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?
More information about the asterisk-users