5 MySQL Queries Every VICIdial Manager Should Run Before 9 AM

VICIdial logs everything. Every dial attempt, every agent state change, every disposition — it all lands in MySQL tables that grow by thousands of rows per hour. The data is there. The problem is that nobody looks at it until something is already on fire. I've managed VICIdial reporting for enough centers to know the pattern: manager walks in, checks the real-time screen, sees agents are logged in, assumes everything is fine. Meanwhile, the drop rate has been creeping toward 3%, three DIDs are flagged as spam, and the hopper ran dry 20 minutes ago on the best-performing campaign. Here are the five queries I run every morning before agents even log in. They take two minutes and catch problems that would otherwise cost you a full shift of lost productivity. After the queries, I'll cover the real-time monitoring cadence that separates centers running blind from centers that catch problems before agents even notice. Query 1: Yesterday's Campaign Health Check This one gives you the overnigh