ZMProv command to dump all e-mail addresses

[cpaul_carling]

Hi,
We use a list of all e-mail addresses on our mail filter as the first line against spam. While I usually remember to update that list everytime I add a Zimbra user, I sometimes forget.

Would there be a zmprov command that can export all e-mail addresses in all the domains, plus the alias addresses, and the distribution list e-mail addresses (not the contents of them).

Thanks

[fyd]

Would there be a zmprov command that can export all e-mail addresses in all the domains, plus the alias addresses, and the distribution list e-mail addresses (not the contents of them).

Hi paul,

'su - zimbra' and

get all email addresses on server - $ zmprov -l gaa
get all domains on server - $ zmprov -l gad
get all accounts under a domain - $ zmprov -l gaa domain.com

All distribution lists on server can be found with $ zmprov gadl
and if you need details on a DL try this one $ zmprov gdl <DLname>

Aliases can be found by looking into 'zimbraMailAlias' field of each mail address.
su - zimbra
$ zmprov ga account@domain.com zimbraMailAlias

now search alias of each accounts on server with a loop
$ for i in `zmprov -l gaa` ; do zmprov ga $i zimbraMailAlias ; done (this will take a while, if an account doesn't have any alias set it the particular result will be blank. Just write the results to a file if the list is too long)

Check '$ zmprov help account' for various switches.

[tomparker.net]

Hey all, I wrote a script that dumps all of the primary email addresses, aliases, and distribution lists in a small efficient shell script. I thought I'd share it here so I don't lose it.

#!/bin/bash

set -o nounset   # exit on unset variables
set -o errexit   # exit if command exits with non-zero value

if [ "$(whoami)" != "zimbra" ]; then
  echo "This script must be run as the zimbra user."
  exit 1
fi

RESULTS=( $(zmprov -l gaa -v | grep -E "zimbraMailAlias|zimbraMailDeliveryAddress" ) )
EMAILS=( ${RESULTS[@]/zimbraMail*/} )
for EMAIL in "${EMAILS[@]}"; do
  echo "$EMAIL"
done
zmprov gadl

Any improvements are welcome. Use it however you like and at your own risk.

[hchan]

I realize this is an old thread but is there a way to generate listings like what's found in the admin console which lists aliases along with their associated Zimbra accounts? The script above is wonderful but the output is a linear list with no linkages between an alias and what it points to.

Thanks in advance.