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 ....