AstRecipes » Removing unclosed entries from the queue_log

To find all single-event calls in your queue_log you can run the following query:

SELECT call_id, count( * ) , verb

FROM queue_log

WHERE partition = 'P001'

AND verb NOT IN (

'AGENTCALLBACKLOGIN', 'AGENTCALLBACKLOGOFF',

'AGENTLOGIN', 'AGENTLOGOFF',

'ADDMEMBER', 'REMOVEMEMBER',

'PAUSEREASON', 'CALLSTATUS'

)

GROUP BY call_id

HAVING count( * ) = 1

Change the partition as you see fit.
Then you should delete them by call-id.

Softlinks:
Installing QueueMetrics - Yum quick-start - Home Page - Compiling Asterisk 1.4 with TDM400 and H323 - Avoiding queue_log file rotation

Tags:
QueueMetrics