[asterisk-users] Queue report statistics

[Jordan Novak]

Here is the run down...
 
billsec is talk time
duration is wait time
dst is the queue extension
lastdata is the queue name
lastapp will show logins
dstchannel is the destination agent
disposition is answered or abandoned status
 
 
Mysql example to show all agent call detail for agent 8000 on queue
number 8877...
( I have a bad habit of using like statements, this will work with = if
you type better than I normally do, just lose the %)
 
SELECT  * FROM cdr WHERE dst LIKE '8877%' AND dstchannel LIKE
'Agent/8000%'
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070417/3bf52e46/attachment.htm