[asterisk-users] Queue Persistence with queue.log

[Steve Totaro]

QueueMetrics is awesome.  I have it halfway implemented and just 
upgraded from 1.2 to 1.2.1 its even better.  Support via this list or 
direct is within minutes which is incredible.  Overkill for your 
situation maybe but for my call center which takes 4,000 calls a day to 
six different queues, it is not at all. 

I have it on it's own dedicated box and use the included scripts to 
"tail" queue_log into the remote mysql database and it works great.  I 
just need to figure out the best way to get call files from the 
dedicated box to the pbx in order to use chanspy but so far I love it.

By the way Garstang, it sounds like you have a very small queuing 
system.  I am sure you are running mysql somewhere, just use the import 
and tail scripts that come with queuemetrics and the DB schema.  Then if 
you know anything about SQL, you can query the database and get all the 
stats you need for free, you don't need JSP, tomcat, or even 
queuemetrics or any patches to run queries.  Just basic SQL knowledge, 
you could even write a basic UI yourself.

Thanks,
Steve

Douglas Garstang wrote:
> Yes, except that if the queue.log file was read by asterisk, and read at restart/reload, they could be pulled with the Manager interface. We are running three Asterisk boxes here in a cluster, and being able to pull the stats from the Manager interface is relatively easy.
>
> I was just looking at QueueMetrics. I have to patch asterisk _and_ use MySQL? and JSP??? Good grief. Talk about overkill. 
>
> Doug.
>
>   
>> -----Original Message-----
>> From: Lenz [mailto:lenz-ml at loway.it]
>> Sent: Friday, July 21, 2006 10:21 AM
>> To: Asterisk Users Mailing List - Non-Commercial Discussion
>> Subject: Re: [asterisk-users] Queue Persistence with queue.log
>>
>>
>>
>> I don't think there is. It would be rather overkill for what 
>> the app_queue  
>> does; there are a number of queue stats packages, commercial 
>> and free,  
>> that will provide a better approach to gathering stats for 
>> the purpouse of  
>> running a call center or an inbound queue.
>> l.
>>
>>
>> On Fri, 21 Jul 2006 16:49:39 +0200, Douglas Garstang  
>> <dgarstang at oneeighty.com> wrote:
>>
>>     
>>> All,
>>>
>>> Is there a way to have Asterisk read queue.log on startup, 
>>>       
>> or reload, so  
>>     
>>> that queue stats can be retained between restarts and 
>>>       
>> reboots? It'd  
>>     
>>> would be especially nice on the reloads, as even a 'reload 
>>>       
>> app_queue.so'  
>>     
>>> clears all your stats. That COMPLETELY sucks, as every time 
>>>       
>> you make a  
>>     
>>> queue configuration change, you lose your stats for ALL queues.
>>>
>>> Doug.
>>>       
>>
>> -- 
>> Loway Research - Home of QueueMetrics
>> http://queuemetrics.loway.it
>>
>> _______________________________________________
>> --Bandwidth and Colocation provided by Easynews.com --
>>
>>
>>     
>
>