docker compose -f /opt/mailcow-dockerized/docker-compose.yml exec mysql-mailcow mysql -u mailcow -p mailcow -e 'SELECT username, active FROM mailbox LIMIT 20;'

Category: Mail Servers & Postfix

docker compose -f /opt/mailcow-dockerized/docker-compose.yml exec mysql-mailcow mysql -u mailcow -p mailcow -e 'SELECT username, active FROM mailbox LIMIT 20;'

List mailboxes and their active flag from MySQL

This queries the mailbox table directly to see every mailbox and whether it is enabled. Faster than paging through the UI when auditing accounts. The active column controls whether login and delivery are permitted.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.