Rendered actual SSH capture — lab-hopper-readiness
LAB01 was inactive. Counts alone do not demonstrate dialing or diagnose the hopper.

[Campaign state]
$ mysql --defaults-extra-file=/etc/vicidial-readonly.cnf --batch vicidb -e "SELECT campaign_id, active, dial_method FROM vicidial_campaigns WHERE campaign_id='LAB01';"
campaign_id	active	dial_method
LAB01	N	MANUAL

[List association]
$ mysql --defaults-extra-file=/etc/vicidial-readonly.cnf --batch vicidb -e "SELECT list_id, campaign_id, active FROM vicidial_lists WHERE list_id=90001 AND campaign_id='LAB01';"
list_id	campaign_id	active
90001	LAB01	Y

[Synthetic lead statuses]
$ mysql --defaults-extra-file=/etc/vicidial-readonly.cnf --batch vicidb -e "SELECT status, COUNT(*) AS lead_count FROM vicidial_list WHERE list_id=90001 GROUP BY status ORDER BY status;"
status	lead_count
NEW	3

[Hopper count]
$ mysql --defaults-extra-file=/etc/vicidial-readonly.cnf --batch vicidb -e "SELECT COUNT(*) AS hopper_count FROM vicidial_hopper WHERE campaign_id='LAB01' AND list_id=90001;"
hopper_count
0