QueueMetrics > Running QueueMetrics

How to delete queue_log records

(1/2) > >>

netsolcr:
Hello...

One agent misslogged in to a queue, so that logged to queue 2080 with agent 2080. It seems that this caused some king of loop. As a consecuense I'm getting a huge number of calls affecting my statistics.

I feel confident that deleting those records will solve my problem. From MySQL y preceed to delete those records, however Queuemetrics reports continue showing statistics for agent 2080, so I restored MySQL database.

How can I get rid of those records?

Thanks in advance for your help.

QueueMetrics:
Deleting them from MySQL will suffice. If QM is still showing those calls, it means you forgot some  ;)

netsolcr:
Please take a look at the report before deleting records:

Agents on queue   
Agent/2080    1885    32.0%    

Querey I'm running in MySQL:
SELECT * FROM `queuemetrics`.`queue_log`
where queue = 2080 and agent like '%2080%'

above query retunrns "3766 rows feched"

then I modify the query as follows:

DELETE FROM `queuemetrics`.`queue_log`
where queue = 2080 and agent like '%2080%'

result:  3766 rows affected by the last command, no resulset returned

So I go back to Queuemetrics reporter, refresh the sesion and run report again...
Please look at the new report results:

Agents on queue   
 Agent/2080     1885      32.0%

As you can see, there is no change in reports after deleting unwanted records.
Am I missing something? should I restart any service? or run any additional process?

Thanks a lot for your help.

QueueMetrics:
Try this:
- look at one of those calls (in QueueMetrics, click on "call detail" and find the caller_id)
- search for that caller_id in the queue_log table (and you'll find one or more call id's)
- select all rows with those call id's

This should make it clear why you're still seeing that agent.

netsolcr:
 ::)

I found many caller_ids in queuemetrics details (some blank); I went to queue_log table in order to find out those records, however this table does not have a caller_id column.

On the other hand.... I realized that a single call if not abandoned would write 3 records in the queue_log table, one of which ones has 'NONE' on agent column. I mean, I previously deleted records where queue = 2080 and agent like '%2080%', so that I missed deleting some records related to affected calls. Well, I already grouped, counted and deleted call_ids < 2 with no changes in queuemetrics reports.

Unwanted records in report:

Agent/2040*    7    0.1%    
Agent/2050    48    0.8%    
Agent/2070    50    0.9%    
Agent/2080    1885    32.7%    
Agent/3562    28    0.5%    

Thanks for your reply.

Navigation

[0] Message Index

[#] Next page