Difference between revisions of "King0770-Notes-Account-Organization"
(Created page with "Here's a command you can use to generate list of all accounts living on their respective <strong>mboxgroup</strong> databases. <code><pre> for i in `seq 1 100`; do echo "Datab...") |
|||
| Line 2: | Line 2: | ||
<code><pre> | <code><pre> | ||
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 | 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 | ||
| − | </pre></code | + | </pre></code> |
Excellent guide on the structure of zimbra accounts, see https://wiki.zimbra.com/wiki/Account_mailbox_database_structure | 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 | ||
| + | |||
| + | [[Category:Community Sandbox]] | ||
| + | [[Category:Command Line Interface]] | ||
| + | [[Category:King0770-Notes]] | ||
Latest revision as of 01:18, 24 April 2019
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
