Queue log into MySQL database


I am trying to develop a wallboard system and I’m struggling to work out how to get detailed Queue data,

What I need is a way to get details on abandoned calls, and then cross linking it with the uniqueid with the CDR database to extract how long the caller was waiting before hanging up and also who it was. Alot of the queue_log guides out there seem to refer to files that I cant find on my distro installed FreePBX.

My question is; is there a robust way of getting the queue log data into a MySQL database in real time?



Some custom dialplan might be in order to write events such as joining the queue and hanging up prematurely to a separate table…but I don’t have the knowledge to confirm this or suggest where to begin on a solution…Might need some more muscle from the rest of the community on this one.