VIcidial tables and Field Descriptions

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

VIcidial tables and Field Descriptions

Postby Mitra » Fri Sep 11, 2020 4:00 pm

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.
Mitra
 
Posts: 3
Joined: Sat Jul 04, 2020 4:05 pm

Re: VIcidial tables and Field Descriptions

Postby williamconley » Thu Oct 22, 2020 8:41 pm

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-)
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: VIcidial tables and Field Descriptions

Postby mflorell » Fri Oct 23, 2020 7:16 am

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
mflorell
Site Admin
 
Posts: 18335
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Re: VIcidial tables and Field Descriptions

Postby Mitra » Thu Dec 31, 2020 8:35 pm

Thank you !
Mitra
 
Posts: 3
Joined: Sat Jul 04, 2020 4:05 pm


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 68 guests