[asterisk-users] Reporting for Asterisk Call Center

[bilal ghayyad]

Dear wcselby;

Thanks a lot for your reply.

For below script, I have some questions if you can help me:

1) I am looking to have reports for the call center, so I need to determine how many calls in the queue, and how many agents logged and when the agent logged in and when logged out ... etc. But I do not see this in the fields created for the CDR, only what I see those fields related to the call it self. So how I can get this?

2) What is required from me to be done to have CDR for the call center? From where to be enabled? In that case, from where I can determine the fields that I have to add it for the cdr table in the database to be able to have cdr for the call center events?

3) Generally speaking, any events will be added in the cdr (those related for calls or call center or any other thing), how can I know the fields that I have to add it to be able to store in the database? Is it the only solution is to look for the Master file to see what the cdr is logging, and based on it I have to create the database?

Appreciate your kindly help.
Regards
Bilal

--------
> > Dear Tark;
> >
> > The asterisk version I am running is 1.8 and I can
> select mysql from
> > menuselect when I am compiling.
> >
> > But when I googled for cdr-mysql, I discovered that I
> have to login for
> > mysql and create the database and run a script to
> create this and give the
> > grants. All what I found in google is related to other
> asterisk versions,
> > while mine is 1.8, so the problem is how to know the
> required script to
> > create the database and give the right grants to be
> used for CDR that suite
> > the version I am running? From where I can get this?
> >
> >
> 
> The following script will generate an "asterisk" database
> with a table named
> "CDR" that will work with asterisk 1.8.  Be sure to
> change 'PASSWORD' with
> whatever password you want to use.
> 
> SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
> CREATE DATABASE `asterisk` DEFAULT CHARACTER SET latin1
> COLLATE
> latin1_swedish_ci;
> USE `asterisk`;
> 
> CREATE TABLE IF NOT EXISTS `cdr` (
> `recid` mediumint(8) unsigned NOT NULL auto_increment
> COMMENT 'Record ID',
> `calldate` datetime NOT NULL default '0000-00-00
> 00:00:00',
> `clid` varchar(80) NOT NULL default '',
> `src` varchar(80) NOT NULL default '',
> `dst` varchar(80) NOT NULL default '',
> `dcontext` varchar(80) NOT NULL default '',
> `channel` varchar(80) NOT NULL default '',
> `dstchannel` varchar(80) NOT NULL default '',
> `lastapp` varchar(80) NOT NULL default '',
> `lastdata` varchar(80) NOT NULL default '',
> `duration` int(11) NOT NULL default '0',
> `billsec` int(11) NOT NULL default '0',
> `disposition` varchar(45) NOT NULL default '',
> `amaflags` int(11) NOT NULL default '0',
> `accountcode` varchar(20) NOT NULL default '',
> `uniqueid` varchar(32) NOT NULL default '',
> `userfield` varchar(255) NOT NULL default '',
> PRIMARY KEY  (`recid`),
> KEY `calldate` (`calldate`),
> KEY `dst` (`dst`),
> KEY `accountcode` (`accountcode`),
> KEY `src` (`src`),
> KEY `disposition` (`disposition`),
> KEY `uniqueid` (`uniqueid`)
> ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
> 
> CREATE USER 'asterisk'@'localhost' IDENTIFIED BY
> 'PASSWORD';
> GRANT FILE ON * . * TO 'asterisk'@'localhost' IDENTIFIED BY
> 'PASSWORD'
> WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0
> MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
> GRANT INSERT ON `asterisk`.`cdr` TO
> 'asterisk'@'localhost';
> 
> 
> If you're going to be running the mysql database on the
> same server as the
> asterisk box, the following cdr_mysql.conf should also work
> for 1.8:
> 
> [global]
> hostname=localhost
> dbname=asterisk
> table=cdr
> password=PASSWORD
> user=asterisk
> port=3306
> sock=/var/lib/mysql/mysql.sock
> userfield=1
> loguniqueid=yes
> 
>