personnal reports

Any and all non-support discussions

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

personnal reports

Postby ehermouet » Fri Sep 06, 2013 3:23 am

Hi all

vicibox 4.0.3
Asterisk v.1.4.44-vici
server virtual for only test

I want to personnalize report.

i try to understand how data are take from database. i see nowhere on my phphmyadmin, this database.

can you explain me where i can found this database ?
ehermouet
 
Posts: 29
Joined: Wed Apr 10, 2013 8:49 am

Re: personnal reports

Postby DomeDan » Fri Sep 06, 2013 4:21 am

If you have a default setup system that installed correctly then you should have a database called asterisk
and in that database there is a table called vicidial_log where you can extract much information,

like for example get the number of calls per agent per campaign the current month:
Code: Select all
SELECT campaign_id, user, count(*) FROM vicidial_log
WHERE MONTH(call_date) = MONTH(CURDATE()) AND user not in ('VDAD','VDCL')
GROUP BY campaign_id, user
Vicidial Partner. Region: Sweden/Norway.
Does Vicidial installation, configuration, customization, add-ons, CRM implementation, support, upgrading, network-related, pentesting etc. Remote and onsite assistance.
Email: domedan (at) gmail.com
DomeDan
 
Posts: 1226
Joined: Tue Jan 04, 2011 9:17 am
Location: Sweden


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 46 guests