search for: from_unixtim

...} } # Query for each date segmentation for(k in 1:length(query_dates)) { #for(k in 4:4) { #for(k in 2:2) { QUERY_DATE<-query_dates[k] userTime<-NULL failures<-NULL # Date Clamp Limits Us To The Middle 80% Of All Data usageDateClamp<-paste(" WHERE FROM_UNIXTIME(submit_time) >= (SELECT ", "FROM_UNIXTIME(MIN(submit_time)) + INTERVAL 0.10*", "DATEDIFF(MAX(FROM_UNIXTIME(submit_time)),MIN(FROM_UNIXTIME(", "submit_time))) DAY FROM ",systems[iter],") AND FROM_UNIXTIME(&qu...

Hi, Surely, I must be overlooking something. If I run the following 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! _______________________________________...

...ot. That did it. >> >> Do you have any idea as to my other issue, the fatal out of memory one? >> >> Thanks. >> Dave. >> >> >> On 4/11/18, Reio Remma <reio at mrstuudio.ee> wrote: >>> Hello, try: >>> >>> SELECT userid, FROM_UNIXTIME(last_login) FROM users; >>> >>> Reio >>> >>> On 11.04.2018 21:39, David Mehler wrote: >>>> Hi, >>>> >>>> Can I get the database display to display those timestamps in a >>>> particular format? >>>> >...

On 22/6/2019 16:07, John Fawcett via dovecot wrote: > > You can easily view the value in a readable format with the > FROM_UNIXTIME mysql funciton > > https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime > > To get remote ip > > define the rip field in your table and add it to the primary key > > add %r to the last_login_key > > last_login_key = last-log...

...ers without problems. With this another SELECT [2], I get the events Abaddon normally. With this other [3] I can get all the channels that joined the queue with no problems. Both tables are recording normally and Asterisk has no errors in the logs. Only happens with the event Abandon. [1] SELECT from_unixtime(ql.time),ql.callid,ql.event FROM cdr c,queue_log ql WHERE c.uniqueid = ql.callid AND ql.event = 'ABANDON'; [2] SELECT * FROM queue_log WHERE event = 'ABANDON'; [3] SELECT from_unixtime(ql.time),ql.callid,ql.event FROM cdr c,queue_log ql WHERE c.uniqueid = ql.callid AND ql.event = &...

Hello, I'm trying to get last login user tracking going, using Dovecot and mysql. I'm using: https://docs.iredmail.org/track.user.last.login.html and it is working, I am seeing an entry and it is updated, the problem is the last login value does not mean anything to me. I was wondering if it's possible to have the value be of a last login date and time, and also a remote ip would be

Hi Timo, all of my tests fail with expire plugin, mail simply not get deleted i cant find any stuff in the logs why it does not or should not work. My guess that there is a problem with virtual plugin and/or shared namespace. It shouldnt be a problem with acl starting the script over cron as root am i right ? do you have any idea why it fails, is there a way to ignore all unneeded shared or

Hello Aki, Thanks for your suggestion. I followed it and the wiki at: https://wiki.dovecot.org/Plugins/LastLogin Good news, I get a record in the users table, with the username that just logged in. This is good. Bad news is I got unexpected output from the last_login time stamp. Here's the table and the user: mysql> describe users;

...anything to me. I was wondering > if it's possible to have the value be of a last login date and time, > and also a remote ip would be helpful so I can see from where users > are logging in from. > > Thanks. > Dave. You can easily view the value in a readable format with the FROM_UNIXTIME mysql funciton https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_from-unixtime To get remote ip define the rip field in your table and add it to the primary key add %r to the last_login_key last_login_key = last-login/%u/%d/%r add $rip to the pattern and fields se...

Hi all, I'm about to start setting up my first asterisk/cti system in our test lab. I've read through all the documentation I can find and relevant posts in the list archives but can't seem to find anything explaining how to go about initiating an http request upon an incoming call. I basically want asterisk to request an uri on our intranet, which will pass call details to our

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