On Tue, Sep 11, 2012 at 4:16 PM, Alex Kink <[email protected]> wrote:
> Hello, > > I'm looking for a solution to automatically generate and email reports that > show how many calls each extension has done today (in and out + total talk > time for each extension). > > Any suggestions are appreciated. > > -Alex > We used to log into MSSQL and generate pretty graphs via our BI team, we also did simple mysql reports via the command line piped into sendmail, both worked nicely. Loading CDR into MySQL is trivial, and doing a mysql -c "select * from CDR where..." statement and piping it into sendmail should do very basic reporting for you. Once you have it in SQL creating graphs / fancy reports is just dependent on what front end you add.. " /usr/bin/mysql asterisk < /etc/asterisk/sql/load-single.sql" ################## LOAD DATA LOCAL INFILE '/var/log/asterisk/cdr/Master.csv' INTO TABLE asterisk.cdr FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' (accountcode, src,dst, dcontext, clid, channel, dstchannel, lastapp, lastdata, calldate, answer, hangup, duration, billsec, disposition, amaflag, uniqueid, custom);
