personnal reports

[ehermouet]

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 ?

[DomeDan]

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