[SOLVED] Looking for reporting output of names, accounts, lists, alias, etc.

[blazeking]

I'm trying to get a list of accounts WITHOUT an alias. I can list all accounts, and list accounts with aliases (with scripts in this forum post), but anyone know of a way to compare those two lists to create one?

[blazeking]

Ok, now I'm trying to get a csv exported of 3 columns: e-mail, first name, last name. The closest I get is from:

zmprov gaa -v | grep -e name -e sn -e givenName | awk 'ORS=","' > all_accounts.csv

But there's a lot of extra "junk" in the output. Anyone know how to get what I'm looking for?

[MOlin]

Mike or anyone,

I'm having permission difficulties.
"zimbra:/Users/zimbra zimbra$ zmprov gdl pga@pubgroup.com > dist-list.txt
su: dist-list.txt: Permission denied"

I'm in the user "zimbra" directory?

Any assistance appreciated!

[blazeking]

The "Zimbra directory" is owned by root, so you won't be able to put files in that folder as the user Zimbra. As the Zimbra user, run this:

mkdir ~/tmp
zmprov gdl pga@pubgroup.com > ~/tmp/dist-list.txt

Your file will be output to /opt/zimbra/tmp (on a default Linux Zimbra install).

[MOlin]

Blazeking,

Thanks for the quick reply. I am on an Mac OSX (10.4) server.

I get this when I run that command:
zimbra:/Users/zimbra zimbra$ mkdir ~/tmp
mkdir: /opt/zimbra/tmp: Permission denied

Obviously, I'm a newbie on the command line. Is there a specific directory I need to be when running this?

[albsallu]

Originally Posted by mmorse

Welcome to the forums,

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

To get a printout of all your accounts:

zmprov gaa > accounts.txt

or

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

or

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

or

 /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:

zmprov gadl > alllists.txt

To print out the members for a given distribution list:

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

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

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:

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

So in this case, the following 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

will get me the username and password that I can use to migrate from one zimbra server to another zimbra server, is that right?