• V20: 3CX Re-engineered. Get V20 for increased security, better call management, a new admin console and Windows softphone. Learn More.

Report by external lines

Status
Not open for further replies.

Jarret

Customer
Joined
Apr 1, 2018
Messages
16
Reaction score
0
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)?
 
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.
 
Status
Not open for further replies.
Get 3CX - Absolutely Free!

Link up your team and customers Phone System Live Chat Video Conferencing

Hosted or Self-managed. Up to 10 users free forever. No credit card. Try risk free.

3CX
A 3CX Account with that email already exists. You will be redirected to the Customer Portal to sign in or reset your password if you've forgotten it.