Page 1 of 1

VIcidial tables and Field Descriptions

PostPosted: Fri Sep 11, 2020 4:00 pm
by Mitra
I am looking to get more information regarding Vicidail tables and each field. (more details about what data is captured on each field).
Could someone guide me to the right resource/link ?
At present I am looking to know what is included in vicidial_closer_log.queue_seconds. Is the Queue sec inlcude the IVR time too or is there a column specifically for IVR time?

Can someone help.

Thanks
Mitra.

Re: VIcidial tables and Field Descriptions

PostPosted: Thu Oct 22, 2020 8:41 pm
by williamconley
1) Welcome to the Party! 8-)

2) As you are obviously new here, I have some suggestions to help us all help you:

When you post, please post your entire configuration including (but not limited to) your installation method (7.X.X?) and vicidial version with build (VERSION: 2.X-XXXx ... BUILD: #####-####).

This IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "manual/from scratch" you must post your operating system with version (and the .iso version from which you installed your original operating system) plus a link to the installation instructions you used. If your installation is "Hosted" list the site name of the host.

If this is a "Cloud" or "Virtual" server, please note the technology involved along with the version of that techology (ie: VMware Server Version 2.0.2). If it is not, merely stating the Motherboard model # and CPU would be helpful.

Similar to This:

Vicibox X.X from .iso | Vicidial X.X.X-XXX Build XXXXXX-XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation | Intel DG35EC | Core2Quad Q6600

3) If I recall correctly: Closer log is for time spent with or waiting for an agent and does not include Call Menu time, but kicks in when the agent passes through an Ingroup or enters a conference with an agent. Call Menu time (which you are calling "IVR") is unrelated to agents. There are reporting options for Call Menus if you read the Vicidial Manager's Manual regarding Call Menus.

FYI:

IVR = Interactive Voice Response: While Vicidial does have some deeper modules and configurations that could allow voice interaction, they are not active on 99.9% of systems, likely including yours based on your question. We just have Call Menus. 8-)

Re: VIcidial tables and Field Descriptions

PostPosted: Fri Oct 23, 2020 7:16 am
by mflorell
We haven't updated this in a few years, but it at least gives an overview of most of the log tables,
http://vicidial.org/docs/LOG_TABLES.txt

Re: VIcidial tables and Field Descriptions

PostPosted: Thu Dec 31, 2020 8:35 pm
by Mitra
Thank you !