ZyXEL Communications IP PBX X6004 - Manual (Page 425)

Chapter 28 Call Detail Record (CDR)
X6004 User’s Guide
425
Each field is described in the following table.
28.5 CDR Technical Reference
This ia a sample of cdr.sql file content.
Table 163 CDR Query > Report
LABEL DESCRIPTION
Left / Right Use the Left and Right icons to change the page you want to view (if the
report has more than one page). Alternatively, use the drop down list
box to select the page you want to view.
Lines/Page Specify how many lines you want to display on each page of the report.
Total This field displays the total records created by this report.
Report Output
Fields The format of your report depends on the criteria you select in the
Report > LOGS > CDR > CDR Query page. See
Section 28.4 on page
422 for explanation of all criteria.
-- mysql -u sqlzyxel -p123456 < cdr.sql
CREATE DATABASE cdr;
GRANT ALL PRIVILEGES ON cdr.* TO sqlzyxel IDENTIFIED BY '123456';
USE cdr;
-- create cdr table
CREATE TABLE IF NOT EXISTS `cdr` (
`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 '',
`userfield` varchar(255) NOT NULL default ''
);
ALTER TABLE `cdr` ADD INDEX ( `calldate` );
ALTER TABLE `cdr` ADD INDEX ( `dst` );
ALTER TABLE `cdr` ADD INDEX ( `accountcode` );