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

</code

Excellent guide on the structure of zimbra accounts, see https://wiki.zimbra.com/wiki/Account_mailbox_database_structure