tags:

views:

72

answers:

2

Asterisk has the following fields

   CREATE TABLE `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 '',
  `uniqueid` varchar(32) NOT NULL default '',
  `userfield` varchar(255) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Most field names are self explanatory, however some fields contain non-self-explanatory data. For instance dst = "s", is anyone aware of documentation that explains this and other pieces of data logged in the CDR table?

+1  A: 

Here you go: http://www.asteriskguide.com/mediawiki/index.php/Asterisk_Call_Detail_Records

Alex K.
That's a good source of info, but I'd like something that explains different cases, like `dst` = "s". It appears that some `dst`='s' are incoming calls transferred from reception, but have no other information associating them to the original incoming caller id.For example: `2010-05-12 15:13:28 244 244 s from-internal SIP/239-0908f990 Zap/9-1 141 136 ANSWERED 3 1273691608.12897`
johnml
+5  A: 

dst is the extension where your call lands

shrikant.soni