search for: calldate

hi, we want to extract the information when the most callers are entering our phone system based on an interval of 15 minutes. this is quite simple (although not perfect) with select calldate, count(*) as anzahl from cdr where calldate > '2019-10-12' group by unix_timestamp(calldate) DIV 900 having ; Unfortunately we have lots of callers who calls multiple times when they are forwarded to a queue instead of being answered by a human immediately. But to know when we need m...

hi,all for a long time, i cant understand the difference between ${CDR(calldate)} and ${CDR(start)} , ${CDR(answer)} i know ${CDR(start)} mean when a call is start. and ${CDR(answer)} means when a call was pick up. but what's ${CDR(calldate)} mean? Could you help me ? Thansk a lot! -- Thanks for your supporting, have a nice day. Sucan

Hi, I am trying to get * log to mssql server. I have odbc and freetds configured, but my insert query is missing calldate which is a NOT NULL field in database schema. cdr_adaptive_odbc: Insert failed on 'sqlserver:cdr'. CDR failed: INSERT INTO cdr (clid,src,dst,dcontext,channel,lastapp,lastdata,duration,billsec,disposition,amaflags,uniqueid) VALUES ('1000','1000','100','sip',...

...i tried cdrzone=GMT, cdrzone=UTC, cdrzone=yes and many combinations with timezone=UTC and without timezone=UTS but cdr is alway in my local timezone GMT +2. in further investigation i have seen there is no timezone conversation. from asterisk1.8.231 mysql_cdr.c if (!strcmp(entry->name, "calldate")) { /*!\note * For some dumb reason, "calldate" used to be formulated using * the datetime the record was posted, rather than the start * time of the ca...

I am not aware what I have done wrong, but the result is a query of: *Database error:* Invalid SQL: SELECT * FROM WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2005-07-01') ORDER BY calldate DESC LIMIT 0,25 *MySQL Error*: 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('...

> Is anybody on this list actually using iax2 for > anything mission-critical? Yes. 2K inbound / outbound calls a day to 30 remote locations, aggregated to 2 PRI's tied together with IAX2. All with IP address specified rather than hostname. All with Asterisk 1.0.9. All with 99.9% completion rate, and it would be 99.999% if we weren't using consumer grade DOCSIS cable modems in the

So I'm noticing from the docs/ on Asterisk Addons 1.4.10 that the database structure for cdr_mysql is: 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 ''...

Hi All, I'm stuck and need some help. I have installed the Asterisk CDR Analyser Version 2.0.1. It mostly works except for the CDR Report. I get the following error even though it lists the CDR details. Database error: Invalid SQL: SELECT substring(calldate,1,10) AS day, sum(duration) AS calltime, count(*) as nbcall FROM cdr WHERE UNIX_TIMESTAMP(calldate) >= UNIX_TIMESTAMP('2008-10-01') GROUP BY substring(calldate,1,10) MySQL Error: 1146 (Table 'asterisk.cdr' doesn't exist)

...r, but userfield is not set. 2. With endbeforehexten=yes, I have two lines in cdr, one with duration, src e dst correct, and a second line with userfield setting and dst h. I am using cdr_odbc.conf, with Asterisk11.14.0 it works fine. May be this is a bug in asterisk13's cdr? pabx=# select calldate,src,dst,duration,billsec,uniqueid,userfield from cdr order by calldate desc limit 2; calldate | src | dst | duration | billsec | uniqueid | userfield ------------------------+------+------+----------+---------+--------------+----------- 2014-11-20 14:37:03-02 | 1901 | h |...

...p("SIP/external-ip-00065fd2", "") in new stack [2014-03-13 09:56:04] VERBOSE[4754] pbx.c: == Spawn extension (from-sip-external, h, 1) exited non-zero on 'SIP/external-ip-00065fd2' It's correct, such call don't allowed , my money is safe. mysql> select calldate, clid,src,dst,dcontext,channel,lastapp,duration,billsec,disposition,amaflags from cdr where calldate like '2014-03-13 09:56:04'; +---------------------+-------------+-----+-----+-------------------+----------------------------+---------+----------+---------+-------------+----------+ | call...

...'; $mysql_password = 'password'; $my_database = 'asteriskcdr'; $dbtable = 'cdr'; $from_date = '20091205000000'; $to_date = '20100104235959'; $callnum = '0'; $minutes = '0'; $query_duration = "SELECT SUM(billsec) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'"; $query_calls = "SELECT COUNT(dst) FROM $dbtable WHERE calldate >= $from_date AND calldate <= $to_date AND disposition='ANSWERED' AND dst like '04%'"; $qu...

I am trying to get cdr via odbc to work on Asterisk 13.7.2 but I keep getting this error: [Feb 9 16:21:43] WARNING[2088]: cdr_odbc.c:160 execute_cb: cdr_odbc: Error in ExecDirect: -1, query is: INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode,uniqueid,userfield,peeraccount,linkedid,sequence) VALUES ({ts '2016-02-09 16:21:28'},?,?,?,?,?,?,?,?,?,?,?,?,?,?,? ,?,?,?) [Feb 9 16:21:43] WARNING[2088]: res_odbc.c:612 ast_odbc_di...

...CRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no loguniqueid=yes loguserfield=yes accountlogs=yes I created the table in the DB so: CREATE TABLE IF NOT EXISTS `cdr` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', `dcontext` varchar(80) COLLATE utf8_bin...

Hi all, I would like to track/store concurrent call usage per user by day/week/month and get server totals by day/week/month. Google comes up with mostly info regarding concurrent call limits, though my goal is to calculate actual concurrent channel usage and add it into reporting. I'm using * 1.6.2 + mysql - realtime (no gui). Any suggestions / open-source / AGI on where to start looking

This is really a query about MySQL which I am trying to use to set up a database which I will then access with RODBC. I have my data in a .csv file, and some of the fields are date/time fields. I tried to create a table using mysql with the definition of the date/time field given by CallDate DATETIME, but I got an error saying that the first row has 28/07/2006 0:00 in that field. What I don't understand is if I open up the .csv file using XEmacs and look at that datum I see 2006-07-28 00:00:00 which mysql should accept as a DATETIME value. If I specify that the field is text wit...

...SQL queries I don't get the same number of rows. Is this coherent? mysql> select * from queue_log where queuename = '4010' and FROM_UNIXTIME(time) between 20080308000000 and 20080313145900 group by callid; 357 rows in set (0.01 sec) mysql> select * from cdr where dst = 4010 and calldate between 20080308000000 and 20080313145900 group by uniqueid; 219 rows in set (0.19 sec) Thanks! ____________________________________________________________________________________ Looking for last minute shopping deals? Find them fast with Yahoo! Search. http://tools.search.yahoo.com...

...more minutes. I ended up with 4 CDR entries. None of the times is anywhere near 4 minutes; they don't even add up to 4 minutes. Any idea how I can get that time to show up in a CDR entry, or any details of how CDRs should work with MeetMe and ChannelRedirect? Here are my 4 CDR entries: calldate=2009-07-26 01:05:32 clid="PPI/SWG" <SWG> src=SWG dst=* dcontext=cob-meetme-escape channel=SIP/SWG-c80008c0 dstchannel=Local/92345678 at callout-d564,1 lastapp=Dial lastdata=Local/92345678 at callout||g duration=20 bill...

...es > unanswered = yes > safeshutdown=yes > > [mysql] > usegmtime=no > loguniqueid=yes > loguserfield=yes > accountlogs=yes > > I created the table in the DB so: > > CREATE TABLE IF NOT EXISTS `cdr` ( > `id` int(11) unsigned NOT NULL AUTO_INCREMENT, > `calldate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', > `clid` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `src` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `dst` varchar(80) COLLATE utf8_bin NOT NULL DEFAULT '', > `dcontext` varch...

...irectory having asterisk call itself to check to make sure its still handling incoming calls correctly, then queries the CDR database in mysql and makes sure that appropriate records exist. I can confirm that the call is happening correctly, but I'm missing records in the database: select calldate, disposition, lastapp, channel from cdr where clid = "xxxxxxxxxx" order by calldate desc limit 45; | 2005-02-14 11:34:04 | ANSWERED | Hangup | Zap/2-1 | | 2005-02-14 11:34:03 | ANSWERED | BackGround | Zap/3-1 | | 2005-02-14 11:32:03 | ANSWERED | Hangup | Zap/1-1 | | 200...

...soft SQL database. I have everything running, but the insert statement being sent to database doesn't appear to have the "start, answer, end" information in it. Below is the insert statement that MS Profiler shows being sent. As you can see those fields are missing. INSERT INTO cdr (calldate,clid,src,dst,dcontext,channel,dstchannel,lastapp,lastdata,duration,billsec,disposition,amaflags,accountcode) VALUES (@P1,@P2,@P3,@P4,@P5,@P6,@P7,@P8,@P9,@P10,@P11,@P12,@P13,@P14) Here is the record that shows up in cdr-csv "","4718","2599576","default",&quo...