Hello Everyone: Before I get crazy writing my own codes, I want to inquire if the hard work has already been done. The type of application I am looking for is more or less a CDR analyzer, whether flat file or sql related, that does similar to what Asterisk-Stat does.
I have very little to know or do from the call records of each user. So far we have been relying on the stats that our v-pri provider has been giving us. My primary intention at this point is to have a detailed stat/logs of: 1. How many channels are being used all together from a SIP Trunk provider/v-pri. 2. How many inbound channels are being used at a given time from a vpri. 3. How many outbound channels are being used at a given time for a vpri. 4. Ultimately how many users are calling each other internally within an Asterisk system at a given time. All of these information can be obtained from the CDR flat files and/or SQL database that contains the CDRs. Before I start writing my queries in mysql, is there anything out there other than "Asterisk-Stat"? If such product is not yet available, I'm ready to write my own AJAX app, that will give me a real time info on how many channels are being used. So basically the product I am looking for is a channel logger/analyzer. Anything out there that anyone can recommend before I go crazy writing an app? Thanks in advance! Reza.
