Asterisk-Stat is providing different reports & Graph to allow
the Asterisk-admin to analyse quickly and easily the traffic on their Asterisk server.
All the graphic & reports are based over the CDR database.

- CDR REPORT (MONTHLY or DAILY)
- MONTHLY TRAFFIC
- DAILY LOAD
- COMPARE CALL LOAD WITH PREVIOUS DAYS
- MANY CRITERIAS TO DEFINE THE REPORT
- EXPORT CDR REPORT TO PDF
- EXPORT CDR REPORT TO CSV
- SUPPORT MYSQL & POSTGRESQL
- MANY OTHERS :)

- APACHE / HTTP SERVER
- PHP
- POSTGRESQL OR MYSQL
- PHP-PGSQL OR PHP-MYSQL
- NEED GD LIBRARY
- JPGRAPH_LIB (included)

- IMPROVE SPEED RESULT WITH INDEX:
 POSTGRESQL : CREATE INDEX calldate_ind ON cdr USING btree (calldate)
 MYSQL : ALTER TABLE `cdr` ADD INDEX ( `calldate` )
- [OPTIONAL]
 POSTGRESQL : CREATE INDEX dst_ind ON cdr USING btree (dst)
 POSTGRESQL : CREATE INDEX accountcode_ind ON cdr USING btree (accountcode)
 MYSQL : ALTER TABLE `cdr` ADD INDEX ( `dst` )
 MYSQL : ALTER TABLE `cdr` ADD INDEX ( `accountcode` )

- PSQL (PostgreSQL) 7.2.4
- MYSQL Ver 11.18 Distrib 3.23.58

Edit defines.php files
WEBROOT: This is the root URL of the application.
 Example: http://youdomain.com/asterisk-stat/
FSROOT: This is the server path which contain the application.
Example: /home/users/asterisk-stat/
HOST: This is the Database host name.
Example: localhost
PORT: Database port.
Example: 5432
USER: Username to access to the database.
Example: username
PASS: Database password of the user.
Example: password
DBNAME: Name of the Database.
Example: asteriskcdr
DB_TYPE: Database type.
support: mysql and postgres
DB_TABLENAME: Table of the database containing the CDR.
Example: cdrtable
appli_list: PHP array used to associate extension to a name. This can be useful if you want to give more signification during the CDR browsing
$appli_list['4677']=array("Voicemail");
$appli_list['6544']=array("Conference-MeetMe");

PROJECT PAGE : asterisk-stat v2 link

DOWNLOAD :

TAR-GZ : asterisk-stat V 2.0