King0770-Notes-Account-Organization
Here's a command you can use to generate list of all accounts living on their respective mboxgroup databases.
for i in `seq 1 100`; do echo "Database: mboxgroup$i"; echo "---------------------"; mysql zimbra -NBe "select id,comment from mailbox where group_id=$i;"; echo; echo; done
Excellent guide on the structure of zimbra accounts, see https://wiki.zimbra.com/wiki/Account_mailbox_database_structure
More articles written by me, https://wiki.zimbra.com/wiki/King0770-Notes