[SOLVED] Listing Distribution List Members

[rwjblue]

We have been using the distribution lists feature via the Admin UI for a while now, and we keep finding more and more uses for them. The only problem that we have come across (caused by us) is that we need to periodically audit the members of each distribution list. We do this to make sure that all required users are on each list, and that no one is on a list that they shouldn't be.

I did not see anything already available that did this so I put together a real basic LDAP query to accomplish this task. I figured that if I needed to do this someone else would also, so here is the basic query to list the members of all distribution lists:

ldapsearch -x -v -H 'ldap://localhost/' -b 'ou=people,dc=mydomain,dc=com' "objectClass=zimbraDistributionList" mail zimbraMailForwardingAddress

If you only want to list a single distribution list you can run the query as follows:

ldapsearch -x -v -H 'ldap://localhost/' -b 'uid=distributionlistname,ou=people,dc=mydomain,dc=com' "objectClass=zimbraDistributionList" mail zimbraMailForwardingAddress

These commands need to be run as the zimbra user. Also, make sure you replace these strings:

mydomain - should be your domain name

distributionlistname - should be the name of the distribution list you are trying to list

Hopefully, someone else will get some use out of this.

RobertJ

[mmorse]

Simpler would be to :
su zimbra
zmprov gdl list@domain.com

If you forget the list names:
zmprov gadl (or zmprov gadl domain.com)

[glitch23]

Funny enough I prefer the ldap search query over the zmprov's method since usually the people who ask for such information do not need to know all the information the it provides.

zmprov gadl > /tmp/distlist.tmp
for list in `cat /tmp/distlist.tmp`; do  
zmprov gdl $list > /home/zimbra/temp/$list; 
done

Which will give you a directory full of text files for each distribution list.

Which I might now modify with the ldap queries.