ZimbraMailQuota

Objective

Find out and create csv file with user mail quota ( used and allocated )on Zimbra Server i.e HEROMOOCORP.BIZ

'Zimbra Mail Quota in MB'

Create a new file having extension .sh and use the code below mentioned :-

#!/bin/bash
output="/root/accountusage"
domain="heromotocorp.biz"
touch $output
server=`hostname`
/opt/zimbra/bin/zmprov gqu $server|grep $domain|awk {'print $1" "$3" "$2'}|sort|while read line
do
usage=`echo $line|cut -f2 -d " "`
quota=`echo $line|cut -f3 -d " "`
user=`echo $line|cut -f1 -d " "`
status=`/opt/zimbra/bin/zmprov ga $user | grep  ^zimbraAccountStatus | cut -f2 -d " "`
echo "$user `expr $usage / 1024 / 1024`Mb `expr $quota / 1024 / 1024`Mb ($status account)" >> $output
done

How to run this script

Create a file first /root/accountusage and then perform the given steps :-

Save the file and then execute the cammand :-

#sh -x name.sh