CDR Data

[Zaraab]

Which table stores the CDR(call detailed record) data in the vicidials *asterisk* database? I mean to say in which table the data regarding a call(inbound or outbound, wait time, queue time, date-time, phone number, DID etc etc) datas are saved?

[mflorell]

There is no single log table for all of that information, VICIdial has dozens of log tables: http://vicidial.org/docs/LOG_TABLES.txt

From what you mentioned, these would be the fist ones to look at:
vicidial_log
vicidial_closer_log
vicidial_did_log

[Zaraab]

There is no single log table for all of that information, VICIdial has dozens of log tables: http://vicidial.org/docs/LOG_TABLES.txt

From what you mentioned, these would be the fist ones to look at:
vicidial_log
vicidial_closer_log
vicidial_did_log

Thank you matt! So it means the datas should be grabbed from individual columns and merged by their relational pointers(foreign keys) to have a holistic view of a specific numbers call detail?
If im not wrong!

[mflorell]

Yes, the 'uniqueid' is often the index used across most of the call log tables.

[Zaraab]

Yes, the 'uniqueid' is often the index used across most of the call log tables.

One more thing here,

Total DROP Calls: 0 0% drop/answered: 0%
Average hold time for DROP Calls: 0 seconds
Drop rate for calls >= 5 seconds: 0 0%
Drop rate for calls >= 10 seconds: 0 0%

Does this "Drop rate for calls >= 5 seconds: " means that the calls which were dropped/hung up by customers after waiting for more than 5 seconds in the queue?

[mflorell]

Where exactly are you seeing that?

[Zaraab]

Its in the inbound report v2 -----> https://server/vicidial/AST_CLOSERstats_v2.php

[mflorell]

Yes, your description of that is accurate.

[Zaraab]

Yes, your description of that is accurate.

Thank you so much