ZimbraMailQuota - Revision history

Biswajit at 11:00, 10 July 2014

2014-07-10T11:00:58Z

← Older revision		Revision as of 11:00, 10 July 2014
Line 26:		Line 26:
	done		done

	~~:wq!~~

	~~========================================================================================================================================================~~
	=='''How to run this script'''==
			=='''How to run this script'''==

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

	#sh -x name.sh		#sh -x name.sh

	~~========================================================================================================================================================~~

Biswajit at 10:58, 10 July 2014

2014-07-10T10:58:30Z

← Older revision		Revision as of 10:58, 10 July 2014
Line 4:		Line 4:


	==Objective==		== Objective ==

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

Biswajit at 10:58, 10 July 2014

2014-07-10T10:58:04Z

← Older revision		Revision as of 10:58, 10 July 2014
Line 2:		Line 2:
	[[category:Tetra Clients]]		[[category:Tetra Clients]]

	~~[[Category: HERO MOTO CORP]]~~

	~~[[Category:~~ Zimbra ~~Mail Quota]]~~
			==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''''''==		== ''''''Zimbra Mail Quota in MB''''''==

Vijay: /* Zimbra Mail Quota in MB */

2014-07-10T08:52:14Z

Zimbra Mail Quota in MB

← Older revision		Revision as of 08:52, 10 July 2014
Line 2:		Line 2:
	[[category:Tetra Clients]]		[[category:Tetra Clients]]

	== Zimbra Mail Quota in MB ==		[[Category: HERO MOTO CORP]]

			[[Category: Zimbra Mail Quota]]

			== ''''''Zimbra Mail Quota in MB''''''==

	Create a new file having extension .sh and use the code below mentioned :-		Create a new file having extension .sh and use the code below mentioned :-
Line 19:		Line 23:
	echo "$user `expr $usage / 1024 / 1024`Mb `expr $quota / 1024 / 1024`Mb ($status account)" >> $output		echo "$user `expr $usage / 1024 / 1024`Mb `expr $quota / 1024 / 1024`Mb ($status account)" >> $output
	done		done

			:wq!

	========================================================================================================================================================		========================================================================================================================================================
			=='''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 :-		Save the file and then execute the cammand :-

Biswajit at 05:01, 27 June 2014

2014-06-27T05:01:51Z

← Older revision		Revision as of 05:01, 27 June 2014
Line 1:		Line 1:
			[[category:Heromotocorp Biz]]
			[[category:Tetra Clients]]

	== Zimbra Mail Quota in MB ==		== Zimbra Mail Quota in MB ==
Line 4:		Line 6:
	Create a new file having extension .sh and use the code below mentioned :-		Create a new file having extension .sh and use the code below mentioned :-

	#!/bin/bash		#!/bin/bash
			output="/root/accountusage"
	output="/root/accountusage"		domain="heromotocorp.biz"
			touch $output
	domain="heromotocorp.biz"		server=`hostname`
			/opt/zimbra/bin/zmprov gqu $server\|grep $domain\|awk {'print $1" "$3" "$2'}\|sort\|while read line
	touch $output		do
			usage=`echo $line\|cut -f2 -d " "`
	server=`hostname`		quota=`echo $line\|cut -f3 -d " "`
			user=`echo $line\|cut -f1 -d " "`
	/opt/zimbra/bin/zmprov gqu $server\|grep $domain\|awk {'print $1" "$3" "$2'}\|sort\|while read line		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
	do		done

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

	Save the file and then execute the cammand :-		Save the file and then execute the cammand :-

	#sh -x name.sh		#sh -x name.sh

	========================================================================================================================================================		========================================================================================================================================================

Vijay: /* Zimbra Mail Quota in MB */

2014-06-06T06:44:33Z

Zimbra Mail Quota in MB

← Older revision		Revision as of 06:44, 6 June 2014
Line 15:		Line 15:

	/opt/zimbra/bin/zmprov gqu $server\|grep $domain\|awk {'print $1" "$3" "$2'}\|sort\|while read line		/opt/zimbra/bin/zmprov gqu $server\|grep $domain\|awk {'print $1" "$3" "$2'}\|sort\|while read line

	do		do

Vijay: Script to get all Zimbra User's Mail Quota size in MB

2014-05-21T15:08:59Z

Script to get all Zimbra User's Mail Quota size in MB

New page

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

Save the file and then execute the cammand :-

#sh -x name.sh

========================================================================================================================================================