<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.3059" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>Here is the run
down...</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=218012313-17042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>billsec is talk
time</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>duration is wait
time</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>dst is
the queue extension</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>lastdata is the
queue name</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>lastapp will show
logins</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>dstchannel is the
destination agent</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>disposition is
answered or abandoned status</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=218012313-17042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=218012313-17042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>Mysql example to
show all agent call detail for agent 8000 on queue number
8877...</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>( I have a bad habit
of using like statements, this will work with = if you type better than I
normally do, just lose the %)</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=218012313-17042007></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=218012313-17042007>SELECT * FROM
cdr WHERE dst LIKE '8877%' AND dstchannel LIKE 'Agent/8000%'</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=218012313-17042007></SPAN></FONT> </DIV></BODY></HTML>