<div class="gmail_quote">On Mon, Apr 18, 2011 at 8:18 AM, A J Stiles <span dir="ltr"><<a href="mailto:asterisk_list@earthshod.co.uk">asterisk_list@earthshod.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
If all the details you need to compile your reports can be found in existing<br>
databases (Asterisk's CDR database stores the details of calls; you may need<br>
to get user login/out events from a separate database), </blockquote><div><br>Logging the queue_log to MySQL and then setting up a trigger that inserts/updates data to other tables (such as something like agent_status and call_status), along with the CDR, will allow the OP to get pretty much everything they want. <br>
<br>(<i>OP, if you need something substantially more than the stats I mentioned in my earlier post, definitely feel free to email me with details. That way, not only can I help <u>you</u>, but I can make the open source statistics solution I'm working on even better)</i><br>
</div><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
A hint: Do the whole thing -- or as much of it as it takes to prove to<br>
yourself that you're on the right track -- "by hand" first, entering all the<br>
queries yourself in the mysql prompt (or phpmyadmin), *before* you try to<br>
write a program to do it. You will save yourself much heartache that way.<br>
<font color="#888888"><br></font></blockquote><div><br>AJ, truer words have not been oft spoken! I'd also add that creating views helps if you have complex queries (just to shorten the query that has to be issued from the end program that gets written).<br>
</div></div><br>