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

Andre Gronwald andregronwald78 at gmail.com
Tue Nov 12 09:55:29 CST 2019


i've got it:

select from_unixtime(round((ceiling(unix_timestamp(calldate)/ 900) 
*900))) as intervall, count(distinct(clid)), count(clid) from cdr where 
calldate > '2019-09-01' group by intervall;


Am 12.11.19 um 15:16 schrieb Andre Gronwald:
> would be better to have dates starting with "2019-10-14 08:00:00", 
> "2019-10-14 08:15:00" etc...
> any quick idea? i will search for that anyway.
>
> regards,
> andre




More information about the asterisk-users mailing list