CDR (Call Detail Records)

Site Navigation:

Asterisk-Stat : CDR Analyser

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.




LAST RELEASE : V2.0.1 (07 March 2005)


FEATURES :

• - 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 :)
  

REQUIREMENTS :

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

ADVICES :

• - 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` )
  

TESTED WITH :

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

INSTALL :

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");

DOWNLOAD :

TAR-GZ : asterisk-stat V 2.0.1

---

If you have comments or ideas to improve the CDR-ANALYSER, please drop me an email :)

Screen-shot