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 _______________________________________________ Asterisk-Users mailing list [EMAIL PROTECTED] http://lists.digium.com/mailman/listinfo/asterisk-users
