<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2657.73">
<TITLE>(Another) Queue log analyser</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>Ben,</FONT>
</P>
<P><FONT SIZE=2>I would definitely have use for this application, fantastic start. When will you be making the source available?</FONT>
</P>
<P><FONT SIZE=2>In my reports I use the CLID to look at calls for different agents i.e. call volume by agent.</FONT>
</P>
<P><FONT SIZE=2>Warm Regards</FONT>
</P>
<P><FONT SIZE=2>Shad Mortazavi</FONT>
<BR><FONT SIZE=2>-----------------------</FONT>
<BR><FONT SIZE=2>Nexus Technical Manager</FONT>
<BR><FONT SIZE=2>n|m Nexus Management Inc </FONT>
<BR><FONT SIZE=2>Neutral Bay</FONT>
<BR><FONT SIZE=2>Sydney</FONT>
</P>
<BR>
<P><FONT SIZE=2>Message: 4</FONT>
<BR><FONT SIZE=2>Date: Fri, 15 Oct 2004 09:33:26 +0100</FONT>
<BR><FONT SIZE=2>From: "Ben Merrills" <ben@griffin.com></FONT>
<BR><FONT SIZE=2>Subject: RE: [Asterisk-Users] (Another) Queue log analyser</FONT>
<BR><FONT SIZE=2>To: "Asterisk Users Mailing List - Non-Commercial Discussion"</FONT>
<BR> <FONT SIZE=2><asterisk-users@lists.digium.com></FONT>
<BR><FONT SIZE=2>Message-ID:</FONT>
<BR> <FONT SIZE=2><F8A414D9A70EB941ADE47043DBE5B702579735@exchange.network.griffin.net.uk></FONT>
<BR>
<BR><FONT SIZE=2>Content-Type: text/plain; charset="us-ascii"</FONT>
</P>
<P><FONT SIZE=2>Hi there,</FONT>
</P>
<P><FONT SIZE=2>Cheers for your suggestions, would be great to see the output of some other reports. </FONT>
</P>
<P><FONT SIZE=2>Logins and logouts are available within the engine, just need to represent them in some way now. What do you suggest would be a good format? Typical duration of login? Only problem might be where someone hasn't logged out before their next login statement (no one here ever logs out, because they're all to slack :)</FONT></P>
<P><FONT SIZE=2>Anything you can send me over would be much appreciated, I have no problems in giving you a pre-release copy so you can give some feedback too.</FONT></P>
<P><FONT SIZE=2>Regards,</FONT>
</P>
<P><FONT SIZE=2>Ben Merrills</FONT>
<BR><FONT SIZE=2>Griffin Internet</FONT>
</P>
<P><FONT SIZE=2>T: 0870 8040862</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: asterisk-users-bounces@lists.digium.com</FONT>
<BR><FONT SIZE=2>[<A HREF="mailto:asterisk-users-bounces@lists.digium.com">mailto:asterisk-users-bounces@lists.digium.com</A>] On Behalf Of Wayne Sheppard</FONT>
<BR><FONT SIZE=2>Sent: 14 October 2004 19:08</FONT>
<BR><FONT SIZE=2>To: Asterisk Users Mailing List - Non-Commercial Discussion</FONT>
<BR><FONT SIZE=2>Subject: Re: [Asterisk-Users] (Another) Queue log analyser</FONT>
</P>
<P><FONT SIZE=2>Very nice work Ben, thanks. Here are some additional thoughts -</FONT>
</P>
<P><FONT SIZE=2>One segmentation that might be useful would be to add outbound calling activities as a either a separate column or even view.</FONT></P>
<P><FONT SIZE=2>On agent stats, it would be useful to see login/logout stamps, login time, ready/not ready time (if this can be tracked, not sure).</FONT></P>
<P><FONT SIZE=2>If you would like, I can send you some example reports that are used in a typical call center, contact me directly if you would find that helpful.</FONT></P>
<P><FONT SIZE=2>Cheers,</FONT>
<BR><FONT SIZE=2>Wayne</FONT>
</P>
<P><FONT SIZE=2>Ben Merrills wrote:</FONT>
</P>
<P><FONT SIZE=2>>I've been doing some work on a queue log analyser for a while now, </FONT>
<BR><FONT SIZE=2>>getting the basics in place, an example of which you can find at the</FONT>
<BR><FONT SIZE=2>URL</FONT>
<BR><FONT SIZE=2>>below. However, just wondering what information people think is most </FONT>
<BR><FONT SIZE=2>>useful in a log analyser?</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>At present it includes the following features:</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>># Time periods - specify a period of days from the log which you want</FONT>
<BR><FONT SIZE=2>to</FONT>
<BR><FONT SIZE=2>>generate statistics for (e.g. only the last 14 days) # Templating - </FONT>
<BR><FONT SIZE=2>>allows the stats to be inserted into any html/text template using </FONT>
<BR><FONT SIZE=2>>specific tags to insert stats. This means you could create a number of </FONT>
<BR><FONT SIZE=2>>templates and execute the analyser against them to give different </FONT>
<BR><FONT SIZE=2>>information on different pages (quite flexible).</FONT>
<BR><FONT SIZE=2>># Specify start and end dates - similar to the first feature, except</FONT>
<BR><FONT SIZE=2>you</FONT>
<BR><FONT SIZE=2>>can specify a tight period from your log, not just the last x number of </FONT>
<BR><FONT SIZE=2>>days # Channels/Agents to names - simple text file allows you to </FONT>
<BR><FONT SIZE=2>>specify a name, agent number and a channel - e.g. Ben, Agent/1, </FONT>
<BR><FONT SIZE=2>>Sip/ben. This is</FONT>
<BR><FONT SIZE=2>>then used in the output # instead of raw data</FONT>
<BR><FONT SIZE=2>># JPG graphs - includes a custom class to generate line graphs of </FONT>
<BR><FONT SIZE=2>>information (e.g. hourly call volumes etc)</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>What I want to know though is, what output people would like. At the </FONT>
<BR><FONT SIZE=2>>moment there is an overview of all queues, which includes:</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Total Calls, total connected calls, total abandoned calls, calls </FONT>
<BR><FONT SIZE=2>>abandoned within x seconds, calls exited with key press, Average hold </FONT>
<BR><FONT SIZE=2>>time, max hold time, average talk time</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Agent overview includes:</FONT>
<BR><FONT SIZE=2>>Calls taken, Average talk time</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Graph of call volume per hour of the day Graph of call volume per day </FONT>
<BR><FONT SIZE=2>>(over the period specified)</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Runs under windows (.NET or mono required) or any other OS that support </FONT>
<BR><FONT SIZE=2>>.NET/mono (Linux, Mac, BSD etc)</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>><A HREF="http://muad.xdev.net/Projects/qig/sample.html" TARGET="_blank">http://muad.xdev.net/Projects/qig/sample.html</A></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Not really done anything like this before, so as much input as possible </FONT>
<BR><FONT SIZE=2>>would be appreciated.</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Cheers,</FONT>
<BR><FONT SIZE=2>></FONT>
<BR><FONT SIZE=2>>Ben</FONT>
</P>
</BODY>
</HTML>