Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - tsolaaa

Pages: [1] 2
1
Running QueueMetrics / Confused on QM Versions
« on: August 24, 2012, 18:22:45 »
I apologize in advance if I am in the wrong section.

We are currently running Loway QueueMetrics - 12.2.4 and I noticed on the QM downloads page the current version is at QueueMetrics 12.05

I am probably missing something obvious, but can someone explain this to me?

Thanks!

2
Outbound and QueueMetrics / Re: Agent names are not showing up under Unans.DT & Unans
« on: June 12, 2012, 22:27:48 »
Sure thing!

We are using the prefix 8300 before calls to have QM track them.

We have q-300 set as the queue in QM to track outbound calls.

Here is the output from queue_log in relation to my test calls.

Code: [Select]
1339532160|1339532160.76079|q-300|SIP/2178|ENTERQUEUE|-|901161405942016|
1339532166|NONE|NONE|SIP/2320|UNPAUSEALL|
1339532166|NONE|3011|SIP/2320|UNPAUSE|
1339532166|NONE|3010|SIP/2320|UNPAUSE|
1339532166|NONE|3008|SIP/2320|UNPAUSE|
1339532166|NONE|3009|SIP/2320|UNPAUSE|
1339532171|1339531912.76053|3008|SIP/2320|CONNECT|186|1339532167.76081|3
1339532172|1339532160.76079|q-300|SIP/2178|ABANDON|1|1|12
1339532183|1339532183.76084|q-300|SIP/2178|ENTERQUEUE|-|901161405942016|





3
Outbound and QueueMetrics / Re: Agent names are not showing up under Unans.DT & Unans
« on: June 06, 2012, 00:00:59 »
Quote from: QueueMetrics on June 05, 2012, 11:06:59
I do not seem to be able to see pics

Moved the photos to another host...Try now...

We currently have QM tracking outbound calls by having the agents dial a special prefix before they dial.

Most of the stats that QM is reporting is correct, however QM does not show the agent name under the "Unans.DT" section.



It also doesn't display any data under the "Unans" section under the "Unanswered outbound calls, by agent"



The agents are entered into the database and do appear correctly when running reports for inbound calls.

The agent names also appear for all outbound answered calls. (Under Ans.DT)



Does anyone have any insight into this?

Thank You!

4
Outbound and QueueMetrics / Agent names are not showing up under Unans.DT & Unans
« on: June 01, 2012, 22:09:49 »
We currently have QM tracking outbound calls by having the agents dial a special prefix before they dial.

Most of the stats that QM is reporting is correct, however QM does not show the agent name under the "Unans.DT" section.

https://skitch.com/tsolaaa/86r39/loway-queuemetrics-version-12.2.4

It also doesn't display any data under the "Unans" section under the "Unanswered outbound calls, by agent"

https://skitch.com/tsolaaa/86r4a/loway-queuemetrics-version-12.2.4

The agents are entered into the database and do appear correctly when running reports for inbound calls.

The agent names also appear for all outbound answered calls. (Under Ans.DT)

https://skitch.com/tsolaaa/86r55/loway-queuemetrics-version-12.2.4

Does anyone have any insight into this?

Thank You!

5
Running QueueMetrics / Re: Agent Session Not Appearing under "Agents" tab.
« on: May 30, 2012, 19:35:00 »
Awesome.

We actually do not use QM for payroll purposes, we use it just to monitor the queues and agents directly by their leads.

Thanks for the input. I went ahead and made the change in the conf file and will test it out over the next few days.

Thanks again!

6
Running QueueMetrics / Agent Session Not Appearing under "Agents" tab.
« on: May 30, 2012, 00:24:16 »
Case:

An agent logs into a queue on May 28 2012 and sits there for the duration of his day. He logs in and out of the queue during the work day.

Due to the holiday, he receives no calls. He logs out at the end of the day.

When running a custom report, selecting the agents name, the queue he was a part of and the date (May 28 2012) and navigating to the "Agents" tab,
it shows no information. I am aware that there should be no calls processed, but it shouldn't it show the other data? (Time, Pauses, etc?)\

May 28th 2012 - https://skitch.com/tsolaaa/87k39/loway-queuemetrics-version-12.2.4

Today, he logged into those same queues and made and received calls, the data is now populated:

https://skitch.com/tsolaaa/87k45/loway-queuemetrics-version-12.2.4


My question is, does an agent have to take calls while logged into the queues in order for any data to show inside these fields? Or is something not working as it should?

Running Asterisk 1.8
Running QM - Loway QueueMetrics - 12.2.4

Thank You.

7
QueueMetrics installation / Re: Java error after upgrading Queuemetrics to 1.7.1.13
« on: December 27, 2011, 18:21:10 »
Hey there,


We encountered a similar issue after upgrading to 1.7.1.13.

Diff your Web.XML file from the old version to the new version after the upgrade.

If you have a custom MYSQL password like we do, you will need to update the web.xml file to reflect that password.


Code: [Select]
<param-value>jdbc:mysql://localhost/queuemetrics?sessionVariables=sql_mode=''&amp;autoReconnect=true&amp;zeroDateTimeBehavior=convertToNull&amp;jdbcCompliantTruncation=false&amp;user=queuemetrics&amp;password=javadude</param-value>     <---- javadude should be changed to reflect whatever your MYSQL password is.

Hope this helps!

8
Running QueueMetrics / Re: Logrotate & Queuemetrics Issue
« on: September 06, 2011, 20:39:04 »
Quote from: QueueMetrics on August 26, 2011, 12:27:37
You could have a sliding windows of 2x the shift, but this adds a bit of load on the server.

So that will keep an agents logged in status for x2 the time of the shift?

Or

will that keep an agents status forever/until that agent logs out.


9
Running QueueMetrics / Re: Logrotate & Queuemetrics Issue
« on: August 25, 2011, 20:12:30 »
Our agents constantly forget to log out at the end of their shift. We do not have a way of forcing them to log out.

Therefore, we are trying to find the best method of having Queuemetrics keep reporting an agents status, even if they forget to log out at the end of their shift.

If I understand correctly, by using a sliding window, QM will gather agent data minus XX hours. (Whatever is set in the realtime.startHour=sXX)  However, this is still a limitation because

it will drop agents from the real-time page after the sliding window time expires.

I am asking if there is any way around this, so that QM will always report an agents status until that agent actually logs off.



10
Running QueueMetrics / Re: Logrotate & Queuemetrics Issue
« on: August 25, 2011, 07:08:40 »
I am honestly not sure what you are saying.   :-\

In a perfect world, I would love to have all the agents log out at the end of the day and if not, have their supervisors do it for them, but that is not possible.

I am just looking for the best method to have Queuemetrics not drop logged in agents when the clock hits midnight.

Our current setting:

#The hour of the day to start realtime monitoring or sXX: sliding window of XX hours
realtime.startHour=0

What can you recommend to be the best practice to have Queuemetrics not drop logged in agents at midnight, if we have three shifts (Morning, Noon and Grave), each lasting ten hours, being a 24/7 company.

I apologize for not understanding, but I do not what to change a setting without understanding how it fully works.



11
Running QueueMetrics / Re: Logrotate & Queuemetrics Issue
« on: August 12, 2011, 18:48:30 »
So I have changed the value from "0" to "s12" since we have 3 separate shifts all working for 10 hours.

Is there any possibility of any future releases of QM to keep an agent state and keep track of who's logged in and out instead of parsing the log file every time? I understand the need for the sliding window for performance concerns, however once the sliding window expires and that agent has not logged out, QM stops reporting that agent, and then we start to accumulate "logged in" agents who aren't being shown in QM.

Thanks for your support.

12
MySQL storage and Qloaderd/Uniloader / Re: MySQL performance issues
« on: July 26, 2011, 20:36:47 »
UPDATE:

We ran

Code: [Select]
ALTER TABLE `queue_log` ORDER BY `time_id`
Again, and it seemed to fix the problem. We currently set up a cron job to have this run twice a month.

Will update to see if this completely revolves the issue.

13
Running QueueMetrics / Re: Logrotate & Queuemetrics Issue
« on: July 26, 2011, 19:48:04 »
Quote
If you're using a DB as a queue data source for QueueMetrics this is not related to the log-rotation of your queue_log file.
This is, more probably, something is reported to this FAQ: http://www.queuemetrics.com/faq.jsp#faq-020-midnight-rt

We are currently a 24/7 call center, could you recommend the correct value for realtime.startHour ?

Currently we are set at

#The hour of the day to start real-time monitoring or sXX: sliding window of XX hours
realtime.startHour=0

I want to avoid making any changes without knowing the possible implications.

Thank you.



14
MySQL storage and Qloaderd/Uniloader / Re: MySQL performance issues
« on: July 19, 2011, 00:06:45 »
So this is the last thing we tried and it was working since then.

However, as of this morning, we are hitting the problem again.

Running the MYSQL tuner script.

Code: [Select]
[tr][td]-------- Performance Metrics -------------------------------------------------
[--] Up for: 3d 14h 11m 52s (1M q [3.673 qps], 100K conn, TX: 53B, RX: 183M)
[--] Reads / Writes: 58% / 42%
[--] Total buffers: 330.0M global + 34.6M per thread (130 max threads)
[OK] Maximum possible memory usage: 4.7G (60% of installed RAM)
[!!] Slow queries: 11% (134K/1M)
[!!] Highest connection usage: 97%  (127/130)
[OK] Key buffer size / total MyISAM indexes: 64.0M/50.9M
[OK] Key buffer hit rate: 100.0% (379M cached / 25K reads)
[OK] Query cache efficiency: 51.8% (128K cached / 247K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 234 sorts)
[OK] Temporary tables created on disk: 1% (3K on disk / 209K total)
[OK] Thread cache hit rate: 99% (215 created / 100K connections)
[!!] Table cache hit rate: 0% (181 open / 160K opened)
[OK] Open file limit used: 10% (233/2K)
[OK] Table locks acquired immediately: 100% (278K immediate / 278K locks)[/sub]

We are still getting a ton of slow queries that make the CPU max out.

I have checked with anyone logged into the machine, and no is is running any insane reports, etc.


Here is an example of the "show processlist;"

Code: [Select]
mysql> show processlist;
+--------+--------------+---------------------+--------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id     | User         | Host                | db           | Command | Time | State        | Info                                                                                                 |
+--------+--------------+---------------------+--------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 101270 | queuemetrics | localhost:40641     | queuemetrics | Query   |  132 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101271 | queuemetrics | localhost:40642     | queuemetrics | Query   |  129 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101272 | queuemetrics | localhost:40643     | queuemetrics | Query   |  127 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101274 | queuemetrics | localhost:40644     | queuemetrics | Query   |  126 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101275 | queuemetrics | localhost:40645     | queuemetrics | Query   |  126 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101276 | queuemetrics | localhost:40646     | queuemetrics | Query   |  124 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101277 | queuemetrics | localhost:40647     | queuemetrics | Query   |  116 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101278 | queuemetrics | localhost:40648     | queuemetrics | Query   |  116 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101279 | queuemetrics | localhost:40649     | queuemetrics | Query   |  114 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101280 | queuemetrics | localhost:40650     | queuemetrics | Query   |  103 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101281 | queuemetrics | localhost:40651     | queuemetrics | Query   |  102 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101282 | queuemetrics | localhost:40652     | queuemetrics | Query   |   94 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101284 | queuemetrics | localhost:40653     | queuemetrics | Query   |   83 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101285 | queuemetrics | localhost:40654     | queuemetrics | Query   |   82 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101286 | queuemetrics | localhost:40655     | queuemetrics | Query   |   80 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101287 | queuemetrics | localhost:40656     | queuemetrics | Query   |   82 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101289 | queuemetrics | localhost:40657     | queuemetrics | Query   |   80 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101290 | queuemetrics | localhost:40658     | queuemetrics | Query   |   80 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101291 | queuemetrics | localhost:40659     | queuemetrics | Query   |   77 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101292 | queuemetrics | localhost:40660     | queuemetrics | Query   |   69 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101293 | queuemetrics | localhost:40661     | queuemetrics | Query   |   69 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101294 | queuemetrics | localhost:40662     | queuemetrics | Query   |   68 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101295 | queuemetrics | localhost:40663     | queuemetrics | Query   |   61 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101297 | queuemetrics | 64.207.128.55:41921 | queuemetrics | Sleep   |    5 |              | NULL                                                                                                 |
| 101298 | queuemetrics | localhost:53878     | queuemetrics | Query   |   47 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101299 | queuemetrics | localhost:53879     | queuemetrics | Query   |   44 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101301 | queuemetrics | localhost:53880     | queuemetrics | Query   |   40 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101302 | queuemetrics | localhost:53881     | queuemetrics | Query   |   39 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101303 | queuemetrics | localhost:53882     | queuemetrics | Query   |   39 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101304 | queuemetrics | localhost:53883     | queuemetrics | Query   |   36 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101305 | queuemetrics | localhost:53884     | queuemetrics | Query   |   28 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101306 | queuemetrics | localhost:53885     | queuemetrics | Query   |   25 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101307 | queuemetrics | localhost:53886     | queuemetrics | Query   |   25 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101308 | queuemetrics | localhost:53887     | queuemetrics | Query   |   19 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101309 | queuemetrics | localhost:53888     | queuemetrics | Query   |   16 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101310 | queuemetrics | localhost:53889     | queuemetrics | Query   |   11 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101311 | queuemetrics | localhost:53890     | queuemetrics | Query   |    6 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101312 | queuemetrics | localhost:53891     | queuemetrics | Query   |    6 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101313 | queuemetrics | localhost:53892     | queuemetrics | Query   |    5 | Sending data | SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue |
| 101314 | root         | localhost           | queuemetrics | Query   |    0 | NULL         | show processlist                                                                                     |
+--------+--------------+---------------------+--------------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
40 rows in set (0.00 sec)



Also, here is some of the slow query logs

Code: [Select]


[root@qm log]# tail -f mysqld.slow.log
# Time: 110718 14:29:07
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 146  Lock_time: 0  Rows_sent: 30578  Rows_examined: 2136443
SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1310972400' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3011'  , '3010'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3009'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC;
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 22
INSERT INTO temp_union_556553 SELECT id_coda , nome_coda ,  LCASE(composizione_coda) AS composizione_coda,  LCASE(agenti_membri) AS agenti_membri ,  LCASE(agenti_spilloff_1) AS agenti_spilloff_1 ,  LCASE(agenti_spilloff_2) AS agenti_spilloff_2 , wrapuptime , announcement_duration , visibility_key , q_direction , sl_calls_y , sl_calls_r , sl_ag_calls_y , sl_ag_calls_r , sl_ag_wait_y , sl_ag_wait_r , sl_ag_pause_y , sl_ag_pause_r , sl_waittime_y , sl_waittime_r , sl_talktime_y , sl_talktime_r  FROM code_possibili WHERE   composizione_coda IN ( '3003', '3004', '3005', '3006', '3008', '3009', '3010', '3011', 'q-301',  'dummy-close-list' );
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 10  Rows_examined: 10
SELECT * FROM temp_union_556553;
# Time: 110718 14:29:11
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 148  Lock_time: 0  Rows_sent: 1125  Rows_examined: 2136443
SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1310972400' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , '3000'  , 'none'  , 'q-300' )   ORDER BY time_id ASC , unique_row_count ASC;
# Time: 110718 14:29:13
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 3  Rows_examined: 3
SELECT * FROM temp_union_567841;
# Time: 110718 14:29:14
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 141  Lock_time: 0  Rows_sent: 30585  Rows_examined: 2136454
SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1310972400' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3011'  , '3010'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3009'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC;
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 22
INSERT INTO temp_union_687716 SELECT id_coda , nome_coda ,  LCASE(composizione_coda) AS composizione_coda,  LCASE(agenti_membri) AS agenti_membri ,  LCASE(agenti_spilloff_1) AS agenti_spilloff_1 ,  LCASE(agenti_spilloff_2) AS agenti_spilloff_2 , wrapuptime , announcement_duration , visibility_key , q_direction , sl_calls_y , sl_calls_r , sl_ag_calls_y , sl_ag_calls_r , sl_ag_wait_y , sl_ag_wait_r , sl_ag_pause_y , sl_ag_pause_r , sl_waittime_y , sl_waittime_r , sl_talktime_y , sl_talktime_r  FROM code_possibili WHERE   composizione_coda IN ( '3003', '3004', '3005', '3006', '3008', '3009', '3010', '3011', 'q-301',  'dummy-close-list' );
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 10  Rows_examined: 10
SELECT * FROM temp_union_687716;
# Time: 110718 14:29:20
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 142  Lock_time: 0  Rows_sent: 1131  Rows_examined: 2136459
SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1310972400' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , '3000'  , 'none'  , 'q-300' )   ORDER BY time_id ASC , unique_row_count ASC;
# Time: 110718 14:29:24
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 143  Lock_time: 0  Rows_sent: 1135  Rows_examined: 2136473
SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1310972400' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , '3000'  , 'none'  , 'q-300' )   ORDER BY time_id ASC , unique_row_count ASC;
# Time: 110718 14:29:33
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 152  Lock_time: 0  Rows_sent: 30598  Rows_examined: 2136473
SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1310972400' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3011'  , '3010'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3009'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC;
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 22
INSERT INTO temp_union_266575 SELECT id_coda , nome_coda ,  LCASE(composizione_coda) AS composizione_coda,  LCASE(agenti_membri) AS agenti_membri ,  LCASE(agenti_spilloff_1) AS agenti_spilloff_1 ,  LCASE(agenti_spilloff_2) AS agenti_spilloff_2 , wrapuptime , announcement_duration , visibility_key , q_direction , sl_calls_y , sl_calls_r , sl_ag_calls_y , sl_ag_calls_r , sl_ag_wait_y , sl_ag_wait_r , sl_ag_pause_y , sl_ag_pause_r , sl_waittime_y , sl_waittime_r , sl_talktime_y , sl_talktime_r  FROM code_possibili WHERE   composizione_coda IN ( '3003', '3004', '3005', '3006', '3008', '3009', '3010', '3011', 'q-301',  'dummy-close-list' );
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 10  Rows_examined: 10
SELECT * FROM temp_union_266575;
# Time: 110718 14:29:34
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 3  Rows_examined: 3
SELECT * FROM temp_union_155538;
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 154  Lock_time: 0  Rows_sent: 30598  Rows_examined: 2136471
SELECT time_id , call_id , queue , agent , verb , data1 , data2 , data3 , data4 , data5   FROM queue_log  WHERE  partition ='P001' AND        (time_id >= '1310972400' AND time_id<='1577869260')     AND queue IN ( '', 'NONE'  , 'q-301'  , '3011'  , '3010'  , '3005'  , '3006'  , 'none'  , '3003'  , '3004'  , '3009'  , '3008' )   ORDER BY time_id ASC , unique_row_count ASC;
# Time: 110718 14:29:35
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 0  Rows_examined: 22
INSERT INTO temp_union_813568 SELECT id_coda , nome_coda ,  LCASE(composizione_coda) AS composizione_coda,  LCASE(agenti_membri) AS agenti_membri ,  LCASE(agenti_spilloff_1) AS agenti_spilloff_1 ,  LCASE(agenti_spilloff_2) AS agenti_spilloff_2 , wrapuptime , announcement_duration , visibility_key , q_direction , sl_calls_y , sl_calls_r , sl_ag_calls_y , sl_ag_calls_r , sl_ag_wait_y , sl_ag_wait_r , sl_ag_pause_y , sl_ag_pause_r , sl_waittime_y , sl_waittime_r , sl_talktime_y , sl_talktime_r  FROM code_possibili WHERE   composizione_coda IN ( '3003', '3004', '3005', '3006', '3008', '3009', '3010', '3011', 'q-301',  'dummy-close-list' );
# User@Host: queuemetrics[queuemetrics] @ localhost [127.0.0.1]
# Query_time: 0  Lock_time: 0  Rows_sent: 10  Rows_examined: 10
SELECT * FROM temp_union_813568;
# Time: 110718 14:29:30

15
Running QueueMetrics / Logrotate & Queuemetrics Issue
« on: July 15, 2011, 18:10:30 »
Hello Everyone,

We are running Queuemetrics 1.7.1.0 with Asterisk 1.8.3 and logrotate.

Every night at 12:00 we have logrotate run, when this happens any agents listed in the Real-Time page on QM disappears.

I'm guessing this happens because QM no longer sees the agents active in the logs and thinks they have left the queue.

Has anyone else had this issue or found a work-around?

Thanks!


Pages: [1] 2