[asterisk-users] Reporting for Asterisk Call Center

[bilal ghayyad]

Dear;

In case I need to retreive the real time data (for example, how many calls currently in the queue, and how many calls currently waiting in the queue, how many agents currently are logged in ... etc).

How to get this?
Is it using the AGI? From where I can get information about this?

Because in the CDR, there is nothing mention or can be obtained for these informations (how many in the queue and how many is waiting .. etc), correct?

Thanks for advance.
Regards
Bilal



-------------------

> 
> 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
>