King0770-Notes-Account-Organization: Difference between revisions
(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...") |
No edit summary |
||
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