[Asterisk-Users] Request for comments on queue statistics

[Paul Crick]

Hi David, group..

I definitely agree that some kind of external statistics would be of great
benefit. I implemented some event logging on an IVR system I worked on
recently, where events were stored in a table related back to the unique ID
in the CDR record (so one CDR, many events) and it worked quite well - nice
and easy to get answers to the questions management like to ask.

I also like the idea of logging to text files - it's plain and simple and
doesn't require the use of MySQL (not sure where we stand on licensing for
something like that?) (I guess not a big issue if this is an optional
thing?).

But bounce back to the other side of the fence, I'd have to say my
preference would be to have stats in a MySQL database purely for ease of
access. Have some pretty web pages displaying near real time queue
statistics etc.. sexy!

I guess one of the questions is whether you go with an event logging type
system, one call having multiple records, with the downside of having to
maybe do some other processing later (working out the time between events
etc?) or have a single record per call with multiple fields defining the
events of the call's lifetime. The record could only be written at the end
of the call which means no information would be available for calls in
progress, although maybe in-progress calls could have records written and
updated every xx seconds with a flag showing when the call/record is
complete? *shrugs* just tossing ideas around there..

I've played with LED readerboad signs before and they're pretty easy to
program up - Does anyone else on the list have any interest in making these
ACD stats available in this way?

Cheers
Paul