I have taken over the support of a freepbx installation at a business that relies heavily on the call reports. They previously used a Samsung Office serv that gave reports that included things like:
Calls per extension
Calls per hour.
I have tried asternic etc, and whilst very nice, their support is non existant, which wont work. There also appears to be no way to exclude internal calls.
I have tried the queue reports plugin and its an embarrassment (for the money). Its full of bugs at multiple levels and provides very little additional functionality over the built in CDR - Reports page.
I think I may be able to work with the CDR Reports output. So 2 questions:
Is there anything that can email a report on the hour with the required information?
If no, is there anyway to automate the CDR-Reports output in a cron job, and then email that output as a PDF, to a destination?
I am at my witts end with this, and am at risk of having to terminate the relationship with the customer as I am not able to give a simple call report that they have asked for.
I have an example report from the old system but am not able to post a link up here
Everything you want should be in your “cdr” table in the “asteriskcdrdb”. I don’t have time to do it today, but writing a PERL script to grovel through the database on an hourly basis and pulling the data out should be reasonably trivial.
Run the program against the database once an hour and have the output sent to you. Unless you want something tricky like building into a spreadsheet with pages per hour, it really should go really quickly.
If you’d be more comfortable with a commercial product, there are plenty of Asterisk Reporting programs out there that should be able to do what you need.
Remember - FreePBX is mostly a management portal. The data that you want is Asterisk data, and that’s a well-understood and commercially supportable set of systems.