Ringing time in CDR

[nicojmb]

Hi,

I'm trying to understand how CDR format the data and i d'ont know in witch field is the Ringing time of wainting queue.

In my CDR time_start and time_answered always is the same value, example:



Regards!

 

[VoIPTools]

You have to understand that the CDR data is a SUMMARY of the entire call. So, if for example, the call was initially routed to an IVR, then a queue, then an agent, then transferred to a manager, all these legs are summarized into the total time. You do not get the ringing time of an individual leg of the call.

If you need more detailed information than what is available in the CDR data, and you cannot get what you need from the built-in 3CX reports, I can suggest you take a look at our 3CX Exporter tool. Exporter replicates to SQL/MySQL all the same data 3CX uses for their built-in reports. This includes, for example, queue statistics where you can get the ringing time (polling). If you REALLY want to go down the rabbit hole and get crazy detailed information about each call, you can also look at our 3CX Monitor tool. Exporter (by default) replicates data every 60 seconds while Monitor is real-time.

 

[nicojmb]

Thanks for your anwser, i will investigate if can acces to pgsql to read the "cl" tables and get the q_waiting time.

 

[VoIPTools]

As long as you understand that directly accessing the PostgreSQL database will likely cause your PBX to be flagged as "unsupported" by 3CX support. They do NOT look kindly at people accessing PostgreSQL.

 

[nicojmb]

As long as you understand that directly accessing the PostgreSQL database will likely cause your PBX to be flagged as "unsupported" by 3CX support. They do NOT look kindly at people accessing PostgreSQL.

Yes, i know that, but i need this value (qeueue waiting time) for a custom project and i think that is temporally until 3cx publish their api.

¿Your software how can access this data? It's supported by 3cx?