Get incoming phone calls from pbx system


I want to know if there is a easy way to get incoming or logged calls from FreePBX and write and log it in a windows app im developing , if there some table in the mysql database i could read , or some file on the linux system.

Thanks for any suggestions!!

Honestly, did you even look at the MySQL databases before asking this question?

If you are going to use them certainly the very obfuscated MySQL command “show databases;” would be something you are aware of? If you don’t even know how to view the databases how are you possibly going to grant permissions for your application to access the DB?

Here is the output of the command. The correct database seems intuitively obvious to me.

mysql> show databases;
| Database           |
| information_schema |
| asterisk           |
| asteriskcdrdb      |
| asteriskrealtime   |
| cacti              |
| endpoints          |
| meetme             |
| mysql              |
| test               |
9 rows in set (0.02 sec)