Report by external lines

[Jarret]

1) There is probably a file containing all information about incoming and outgoing calls, ways of routing connections and many other additional events. Can I have access to a file containing this information? Where this file are located?

2) Is it possible to extract information from the file described in the above using the CDR file? I mean, if the system has been running for a year and today I will enable the generation of a CDR file, will the CDR file contain information about events from before today? Whether however will only this information appear in the file that will arise after the inclusion date of generating the CDR file?

3) I have enabled the generation of a CDR file, but my national number (A, B or C – “source line”, external line) doesn’t have own field. The field containing - among others - my national number has the form: "src_line:src_number". Does this mean that there is no separate field in the CDR file containing only my national number (A, B or C)?

 

[VoIPTools]

Hi Jarret,

You can get the information you are looking for from the CDR files. Please look at the following threads:

https://www.3cx.com/community/threads/cdr-with-sip-trunk.55276/#post-229461
https://www.3cx.com/community/threads/cdr-did-tracking.43543/page-2#post-229069

However, you cannot generate CDR files for past calls. In that case you would need to go directly to the PostgreSQL database. But understand this is not supported and should be a last-resort option. 3CX doesn't like people accessing the database directly. That said, if you have no other choice, you might consider our Exporter tool which can copy the PostgreSQL data to either Microsoft SQL Server or MySQL. Our tool has been in use around the world for about 8 years with no known issues.