[Freeswitch-users] Another Concurrent Calls Monitor Question

[DJB]

I am also curious whether you can recommend how I can get the info if I want to see concurrent calls by account code.  Let's say if I am running FS as SBC and I want to monitor concurrent calls per customer.  I've looked at the HEARTBEAT, but it only gives me overall session-count.

How safe is it if I have a cron job running every 5 minutes, and get the data from core.db in the calls tables.  For instance, if I issue the following query:
select count(*) from calls where substr(callee_chan_name,27,15)='$gw_ip_addr';

I don't want to query directly from core.db, so it would be great if I can use something from event socket to monitor per customer (account code) or ip address.

Thank you.