Information of all from domain mails to a user Amit Srivastava
# This Article is to get Information from the mailbox of a user that from all which domain he/she got the mail.
# Ref: https://wiki.zimbra.com/index.php?title=Account_mailbox_database_structure
# su – zimbra
$ zmprov gmi user@domain.com
mailboxId: 36
quotaUsed: 65146125877
Note: mboxgroup = expr mailboxid % 100
$ expr 36 % 100
36
Note: This means mailbox lie in mboxgroup36
$ mysql mboxgroup36 -e “select * from mail_item where mailbox_id=36” > /tmp/detail.txt
$ cat /tmp/userdetail.txt|grep -E -o "\b[a-zA-Z0-9.-]+@[a-zA-Z0-9.-]+\.[a-zA-Z.-]+\b" | sort -nr| uniq | cut -d'@' -f2,2 | sort -nr |uniq > /tmp/domains.txt