[Asterisk-Users] Queues/Agents

[Frank Mandarino]

Joseph wrote:
> Is there a way to get the que logs to go to a postgresql database?
> 
> And/or are they any documents that explain the layout and field meanings?
> 
> The logs look like they will be very helpful.
> Especially to show how long calls are held and who is taking them.
> 
> I would like to make simple web reporting tool to show a daily summary 
> status of queue activity.
> 
> Also, there is not a manager command to do the equivalent of a "show 
> agents", is there? Other than the "Command" which lets you use a cli 
> command.
> 
> Why does the manager api say "Thanks for the fish" when logging out?
> Not a bad thing but, looks strange on my queue monitor I put together.
> I could code it out, but wondered what it means :) ?
> 
> Thanks for a great product.

Joseph,

I would also like to see queue logging to PostgreSQL.  In my last job, I 
wrote a small Perl program to parse the queue log records and insert 
them into PostgreSQL.  I then used cron to run it at regular intervals.

Unfortunately, I no longer have access to this program.  If you want, 
I'll see if my former employer will let me post it.

The queue log record format is documented in 
/usr/src/asterisk/doc/queuelog.txt.

Regards,
../fam
-- 
Frank Mandarino					fmandarino at endrelia.com
Endrelia Technologies Inc.
Toronto, Ontario, Canada