CDR and incoming - outgoing calls information


#1

Hi @all,

this is my problem:

i do a sql query on cdr in mysql. I want to get all incoming or outgoing calls.
But i can’t find an entry in the table with this information.
So my first idear was to check all my extionsions in src and dst.

But the problem is that if i get an incoming call in dst. it cointains not the extension its the externel nummber the caller dialed. We have Point To Multipoint connection, so any of our extions has there own externel number.
Is it on a Point to Point also?

I hope someone of you has an idea how to get the information if it is an incoming or outgoing call!!!

Thanks. And sorry about my bad english…


#2

Check out the AMP portal
coalescentsystems.ca/