[SOLVED] how to export account details ?

[chandu]

Hi,

I am using zcs-4.5.10 on RHEL 5. and this setup is running with 2 different domains. Now our management required all email accounts details of both domains. SO is there any way by which we can export all email id details from zimbra admin console ??

[phoenix]

You'll have to script it and use the command line (and search the forums for details and wiki) to export account details:

zmprov help commands

[chandu]

hi,
how can i export details for specific domain ?

I used " zmprov gqu <server name> " command but it is using account details for all domains.

Pls help.

Thanks..

[uxbod]

su - zimbra
zmprov gaa {domain}

will list the mailboxes for a particular domain. Are there specific details you are trying to obtain ?

[chandu]

hey thanks for quick response. actually i just wanted all email ID details and by this command i got id.
But for my reference i want alloted mailbox size and used mailbox size of every account. so how to use zmprov for that to specific domain ?

[uxbod]

Something along these lines would do what you want.

su - zimbra

#!/bin/bash

echo "Account            MailQuota                   QuotaUsed"
zmprov gaa {whateverdomain} | while read ACCOUNT
do
    QUOTA=`zmprov ga ${ACCOUNT} | grep "zimbraMailQuota" | awk -F\: '{ print $2 }'`
    USAGE=`zmmailbox -z -m ${ACCOUNT} gms`
    echo "${ACCOUNT}          ${QUOTA}                   ${USAGE}"
done

[chandu]

Hey thank u so much...i got that output which i wanted
Now i m trying to put it in excel ..
thanks again..

[uxbod]

#!/bin/bash

echo "Account,MailQuota,QuotaUsed"
zmprov gaa {whateverdomain} | while read ACCOUNT
do
    QUOTA=`zmprov ga ${ACCOUNT} | grep "zimbraMailQuota" | awk -F\: '{ print $2 }'`
    USAGE=`zmmailbox -z -m ${ACCOUNT} gms`
    echo "${ACCOUNT},${QUOTA},${USAGE}"
done > accounts.csv

Job done

[chandu]

Hi uxbod..thanks for all tricks ...i did below changes and now i am getting very useful output in excel...

#!/bin/bash
rm -fr /root/test.xls
echo "Account MailQuota QuotaUsed AccountStaus">>/root/test.xls
/opt/zimbra/bin/zmprov gaa example.com | while read ACCOUNT
do
QUOTA=`/opt/zimbra/bin/zmprov ga ${ACCOUNT} | grep "zimbraMailQuota" | awk -F\: '{ print $2 }'`
QUOTA=`expr ${QUOTA} / 1024`
QUOTA=`expr ${QUOTA} / 1024`
QUOTA="${QUOTA}MB"
USAGE=`/opt/zimbra/bin/zmmailbox -z -m ${ACCOUNT} gms`
AS=`/opt/zimbra/bin/zmprov ga ${ACCOUNT} | grep zimbraAccountStatus |awk -F\: '{ print $2 }'`


echo "${ACCOUNT} ${QUOTA} ${USAGE} ${AS}">>/root/test.xls
done



and now I am getting below output in excel


Account MailQuota QuotaUsed AccountStatus





thank u so much for ur quick support ....

[uxbod]

Great ... Glad you are getting the report you required