Need Concurrent Calls report

profjake

New Member
Joined
Dec 12, 2019
Messages
3
Reaction score
0
Id like to revive this. I need a Concurrent Calls report that I can run anytime on existing CDR data. There used to be a Concurrent Calls Module you could manually upload and install but it it no longer seems to work. What else can I use to get a Concurrent Call list by hour/day?
 

krzykat

Telecom Strategist
Joined
Aug 2, 2008
Messages
3,145
Reaction score
1,235
Id like to revive this. I need a Concurrent Calls report that I can run anytime on existing CDR data. There used to be a Concurrent Calls Module you could manually upload and install but it it no longer seems to work. What else can I use to get a Concurrent Call list by hour/day?

Which version are you using?
 

profjake

New Member
Joined
Dec 12, 2019
Messages
3
Reaction score
0
Yes good point. Most of our boxes are Incredible PBX 15 and 16 and some are 13.
I think it broke at 13? The contributor to the CDR report module that I used to use hasn't updated it since 2014.
 

profjake

New Member
Joined
Dec 12, 2019
Messages
3
Reaction score
0
Is this what you are trying to use?

Yes that is what I have used before. Or I don't really specifically need that module if I can somehow figure out how to extract it from the CDR with a macro in Excel or something.
 

dicko

Still learning but earning
Joined
Oct 30, 2015
Messages
1,607
Reaction score
826
You could start with

mysql asteriskcdrdb -e 'SELECT WEEKDAY(calldate) AS DayOfWeek, HOUR(calldate) as HourOfDay, COUNT(*) AS CallsPerHour FROM cdr WHERE `calldate` > NOW() - INTERVAL 1 WEEK AND `calldate` < NOW() -interval 1 Day GROUP BY HOUR(calldate), WEEKDAY(calldate) ORDER BY WEEKDAY(calldate), HOUR(calldate)'

for concurrent calls at any 'point in time' count the number of calls where start < 'point in time' and start +duration > 'point in time'
 
Last edited:

Members online

No members online now.

Forum statistics

Threads
25,778
Messages
167,504
Members
19,198
Latest member
serhii
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.
Top