Zimbra - Forums - View Single Post - [SOLVED] Looking for reporting output of names, accounts, lists, alias, etc.

mmorse · #2 (**permalink**) 07-10-2008, 10:59 PM

Welcome to the forums,

Code:

mkdir /opt/zimbra/info
chown zimbra.zimbra /opt/zimbra/info
su - zimbra
cd info

To get a printout of all your accounts:

Code:

zmprov gaa > accounts.txt

or

Code:

zmaccts | grep "@" | awk '{print $1}' > accounts.txt

or

Code:

 /opt/zimbra/bin/zmaccts | grep 'active' | egrep -v '^\W+' | awk '{print $1}'

or

Code:

 /opt/zimbra/openldap/bin/ldapsearch -LLL -x -D"`/opt/zimbra/bin/zmlocalconfig -s zimbra_ldap_userdn | \
       awk '{print $3}'`" -w"`/opt/zimbra/bin/zmlocalconfig -s zimbra_ldap_password | \
       awk '{print $3}'`" -H `/opt/zimbra/bin/zmlocalconfig ldap_url | \
       awk '{print $3}'` $* | \
       grep ^mail | \
       awk '{print $2}' | \
       sort > zimbra_recipients.list

Exporting all addresses - Zimbra :: Wiki

To get a printout of all your distribution lists:

Code:

zmprov gadl > alllists.txt

To print out the members for a given distribution list:

Code:

zmprov gdl dist-list@domain.com > dist-list.txt

To show if that particular distribution list is a member of other distribution lists:

Code:

zmprov gdlm dist-list@domain.com > dist-list-membership.txt

Bug 19157 - Ability to export GAL as a CSV file (admin console)
You can use awk & print to do so from CLI.
For instance:

Code:

zmprov gdl dist-list@domain.com | awk 'ORS=","' > list.csv