[SOLVED] Generate list of all users on server?

[GoneWestCoast]

I'm looking to generate a flatfile list of all users and aliases on the system for use at the gateway MX-- later in time I'll query LDAP directly, but right now that's unworkable for a couple reasons.

There a zmprov command or an LDAP query to do this?

[reza225]

hey try this as the zimbra user

zmaccts | grep "@" | awk '{print $1}'

or just zmaccts for all the information

or

zmaccts | mail -s "ZMACCTS Information" user@example.tld

[GoneWestCoast]

Thanks!

Will this work on aliases and distribution lists as well?

[mmorse]

To get all the lists:
zmprov gadl

or just those in a domain:
zmprov gadl domain.com

get membership info:
zmprov gdlm list@domain.com

to see the members of a particular list:
zmprov gdl list@domain.com

to add a member:
zmprov adlm list@domain.com user@domain.com

to remove a member:
zmprov rdlm list@domain.com user@domain.com

to create a list:
zmprov cdl newlist@domain.com

to delete a list:
zmprov ddl deletethislist@domain.com

rename list:
zmprov rdl list@domain.com newlistname@domain.com

add list alias:
zmprov adla list@domain.com newalias@domain.com

remove list alias:
zmprov rdla list@domain.com aliastoremove@domain.com

[praveen25]

mysql -D zimbra -Be "select comment from mailbox"

[GoneWestCoast]

Hah, wow-- thanks for the help!

I didn't expect to see this updated two years later, but it's definitely appreciated!

[sikander]

Hello All,

This is a very useful link it solved my 90% problem. I can now get list of all the users. little problem is there any way to get the list of all users and print it in a file or export them to my local pc. I have created the file by touch but don't know how can i redirect or save all the user list in a file.

zmaccts | grep "@" | awk '{print $1}'

Thanks in Advance,

Sikander

[uxbod]

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

and then copy the resulting file back to your workstation.

[Panchux]

Many of these commands work well for listing accounts but I need to export it with name and last name too. How should I do it?

Thanks in advance,

Pancho

[sikander]

Hello uxbod,

Thank you for your great support. I have tried on my testing server it is perfectly ok. But when i tried on production it is giving me permission denied error. Even the permissions are same.

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

should i changed the permission If i do then it is not starting postfix correctly. Any other way to generate this account list in a file.

Thanks in Advance,

Sikander