
Yes, I could Google it, but I often get so much more from the experience and opinions here. We have a customer asking for some reporting capabilities such as total calls and call time for specific extensions. Nothing really complex. Probably 70 handsets, and they just need to know how the customer service team is doing (report of calls/time for five phones), sales team, etc.

CDR-STATS.org is what we have used in the past for asterisk rollouts. --I think you guys use asterisk, right? It's an easy to use interface and is pretty robust. It also supports free switch, kamalio, etc We use Akixi for Broadworks Thanks, Shripal
On Feb 22, 2017, at 1:22 PM, Carlos Alvarez <caalvarez at gmail.com> wrote:
Yes, I could Google it, but I often get so much more from the experience and opinions here.
We have a customer asking for some reporting capabilities such as total calls and call time for specific extensions. Nothing really complex. Probably 70 handsets, and they just need to know how the customer service team is doing (report of calls/time for five phones), sales team, etc.
_______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

All of these products seem to require things running on the server, or a server. We're literally looking for something to look at the existing CDR files only. For two reasons--they want to look at historical data, and we prefer not to add cruft to our voice servers. We could put it elsewhere, but then, deploying more infrastructure means a cost we need to pass on. We already use Asternic on a couple of custom servers for call centers. On Wed, Feb 22, 2017 at 12:03 PM, Shripal Daphtary <shripald at gmail.com> wrote:
CDR-STATS.org is what we have used in the past for asterisk rollouts. --I think you guys use asterisk, right?
It's an easy to use interface and is pretty robust.
It also supports free switch, kamalio, etc
We use Akixi for Broadworks
Thanks,
Shripal
On Feb 22, 2017, at 1:22 PM, Carlos Alvarez <caalvarez at gmail.com> wrote:
Yes, I could Google it, but I often get so much more from the experience and opinions here.
We have a customer asking for some reporting capabilities such as total calls and call time for specific extensions. Nothing really complex. Probably 70 handsets, and they just need to know how the customer service team is doing (report of calls/time for five phones), sales team, etc.
_______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

Carlos, While it definitely sides on the "nuclear option" side of solutions and requires a little bit more work I would highly recommend the ELK stack for all your data crunching/visualizing needs Use lightweight filebeat agent to harvest CDR's, feed to logstash for parsing/munging/deposit in elasticsearch then analyze in Kibana. It distributes extremely well and can scale to pretty much any need. Once you get accustomed to digesting data like this you wont go back. DataDog is a hosted version of this but its not hard to build at all. -Ryan On 2/22/2017 11:32 AM, Carlos Alvarez wrote:
All of these products seem to require things running on the server, or a server. We're literally looking for something to look at the existing CDR files only. For two reasons--they want to look at historical data, and we prefer not to add cruft to our voice servers. We could put it elsewhere, but then, deploying more infrastructure means a cost we need to pass on.
We already use Asternic on a couple of custom servers for call centers.
On Wed, Feb 22, 2017 at 12:03 PM, Shripal Daphtary <shripald at gmail.com <mailto:shripald at gmail.com>> wrote:
CDR-STATS.org is what we have used in the past for asterisk rollouts. --I think you guys use asterisk, right?
It's an easy to use interface and is pretty robust.
It also supports free switch, kamalio, etc
We use Akixi for Broadworks
Thanks,
Shripal
> On Feb 22, 2017, at 1:22 PM, Carlos Alvarez <caalvarez at gmail.com <mailto:caalvarez at gmail.com>> wrote: > > Yes, I could Google it, but I often get so much more from the experience and opinions here. > > We have a customer asking for some reporting capabilities such as total calls and call time for specific extensions. Nothing really complex. Probably 70 handsets, and they just need to know how the customer service team is doing (report of calls/time for five phones), sales team, etc. > > _______________________________________________ > VoiceOps mailing list > VoiceOps at voiceops.org <mailto:VoiceOps at voiceops.org> > https://puck.nether.net/mailman/listinfo/voiceops <https://puck.nether.net/mailman/listinfo/voiceops>
_______________________________________________ VoiceOps mailing list VoiceOps at voiceops.org https://puck.nether.net/mailman/listinfo/voiceops

Carlos Alvarez writes:
All of these products seem to require things running on the server, or a server. We're literally looking for something to look at the existing CDR files only. For two reasons--they want to look at historical data, and we prefer not to add cruft to our voice servers. We could put it elsewhere, but then, deploying more infrastructure means a cost we need to pass on.
Honestly for a case this small have you considered just writing a script to parse the CDRs how you like? I did exactly this a few times - parsing the CSV files in python to figure out number of calls,total time per extension, etc. It's really less work than you would think. You might be able to reuse some code from cdr-stats. https://github.com/cdr-stats/cdr-stats/blob/develop/cdr_stats/cdr/cdr_import... https://github.com/cdr-stats/cdr-stats/blob/develop/cdr_stats/cdr/models.py Once you have some basic code that does what you want just schedule a cronjob to run whenever. -jjrh
participants (4)
-
caalvarez@gmail.com
-
justin@credil.org
-
ryandelgrosso@gmail.com
-
shripald@gmail.com