![]() ![]() QlikView Interview Questions and Answers.Top MSBI Interview Questions and Answers.Top Pentaho Interview Questions And Answers.Top Obiee Interview Questions And Answers.Top SAS Interview Questions and Answers.Top Sqoop Interview Questions – Most Asked.Top Hive Interview Questions – Most Asked.Top PIG Interview Questions - Most Asked.Top Couchbase Interview Questions - Most Asked. ![]() Top HDFS Interview Questions And Answers.Top Mapreduce Interview Questions And Answers.Top 40 Apache Spark Interview Questions and Answers in 2023.Top Apache Storm Interview Questions And Answers.Top Apache Solr Interview Questions And Answers.Top 70 Hadoop Interview Questions to Prepare In 2023.Top Splunk Interview Questions and Answers.Top 50 Automation Anywhere Interview Questions and Answers in 2023.Top 50 UiPath Interview Questions and Answers in 2023.Top RPA Interview Questions and Answers.(NEW.agent,'READY',FROM_UNI XTIME(NEW.time),NULL) ON DUPLICATE KEY UPDATE agentStatus = "READY", timestamp = FROM_UNIXTIME(NEW. Where callid = NEW.callid INSERT INTO agent_status (agentId,agentStatus,timestamp,callid) VALUES ON DUPLICATE KEY UPDATE agentStatus = "READY", timestamp = FROM_UNIXTIME(NEW.time), callid = NULL Ĭallduration = replace(substring(substring_index(NEW.data, ‘|’, 3), length(substring_index(NEW.data, ‘|’, 3 - 1)) + 1), ‘|’, ‘’) Where callid = NEW.callid INSERT INTO agent_status (agentId,agentStatus,timestamp,callid) VALUES (NEW.agent,NEW.event,FROM_UNIXTIME(NEW.time),NULL) ![]() OriginalPosition = replace(substring(substring_index(NEW.data, ‘|’, 3), length(substring_index(NEW.data, ‘|’, 3 - 1)) + 1), ‘|’, ‘’), ON DUPLICATE KEY UPDATE agentStatus = NEW.event, timestamp = FROM_UNIXTIME(NEW.time), callid = NEW.callid ĮLSEIF NEW.event in (‘COMPLETECALLER’,‘COMPLETEAGENT’) THEN Where callid = NEW.callid INSERT INTO agent_status (agentId,agentStatus,timestamp,callid) VALUES (NEW.agent,NEW.event, FROM_UNIXTIME(NEW.time), NEW.callid) UPDATE call_status SET callid = NEW.callid, status = NEW.event, timestamp = FROM_UNIXTIME(NEW.time), queue = NEW.queuename, ON DUPLICATE KEY UPDATE agentStatus = “PAUSE”, timestamp = FROM_UNIXTIME(NEW.time), callid = NULL INSERT INTO agent_status (agentId,agentStatus,timestamp,callid) VALUES (NEW.agent,‘PAUSE’,FROM_UNIXTIME(NEW.time),NULL) ON DUPLICATE KEY UPDATE agentStatus = “LOGGEDOUT”, timestamp = FROM_UNIXTIME(NEW.time), callid = NULL INSERT INTO agent_status (agentId,agentStatus,timestamp,callid) VALUES (NEW.agent,‘LOGGEDOUT’,FROM_UNIXTIME(NEW.time),NULL) ON DUPLICATE KEY UPDATE agentStatus = “READY”, timestamp = FROM_UNIXTIME(NEW.time), callid = NULL INSERT INTO agent_status (agentId,agentStatus,timestamp,callid) VALUES (NEW.agent,‘READY’,FROM_UNIXTIME(NEW.time),NULL) bi_queueEvents BEFORE INSERT ON asterisk. = Agent ‘1000’ logged in (format ulaw/ulaw) ![]() WARNING: config.c:2018 find_engine: Realtime mapping for ‘queue_log’ found to engine ‘mysql’, but the engine is not available – Started music on hold, class ‘default’, on SIP/1000-00000003 – Playing ‘agent-loginok.gsm’ (language ‘en’) But its not going to DB though the entries are there in the ‘/var/log/asterisk/queue_log’. I want to log the queue_log data in to mysql DB. I have asterisk 1.6.2.22 installed on my centOS. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |