[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?