extract account info

[jas78]

Hi Guys,
Is it possible to extract certain account info from zimbra?

The info that I need is
1) We require the list all the accounts that have set up forwarding in the system. The output the: ID, Name, Trainee Email Address, the email address the emails has been forwarded to.

2) A list of all the email accounts, size in MegaBytes and the total number of emails.

I try to use zmaccts however I only get the list for Account, status, created and last logon
Also with zmprov -l gaa only give me all the lists of the email.

Thanks for your help

[FritzBrause]

Originally Posted by jas78

Hi Guys,
Is it possible to extract certain account info from zimbra?

The info that I need is
1) We require the list all the accounts that have set up forwarding in the system. The output the: ID, Name, Trainee Email Address, the email address the emails has been forwarded to.

Basic information if the Account has a forwarding address enabled can be obtained by

for account in `zmprov -l gaa`; do echo "Account: $account"; zmprov ga $account | grep zimbraPrefMailForwardingAddress; echo; done

2) A list of all the email accounts, size in MegaBytes and the total number of emails.

I try to use zmaccts however I only get the list for Account, status, created and last logon
Also with zmprov -l gaa only give me all the lists of the email.

Thanks for your help

Try

zmprov gqu localhost

for basic information or modify a script from here Quota Warning Script - Zimbra :: Wiki to fit your needs.

Regards

[Cine.ZxCommunity]

Hi!

This two commands might be useful for you:

1)

zmprov -l  gaa -v|grep "zimbraId:\|\# name\|orwardingAddress\|zimbraMailDeliveryAddress"

(sorry, I didn't get what you mean by Trainee Email Address..)

2)

 zmprov gqu `zmhostname` |awk  '{print $1";"$3}'

(Prints out mailbox;quotausage couples, in bytes.)

Both commands must be run as the zimbra user..

Enjoy!

[EDIT: Seems I got second ]

Cine - Community Manager - ZeXtras
www.zextras.com

[jas78]

Thanks for all the reply. You guys are awesome. I will try it once I am in the office tomorrow morning