• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3315
  • Last Modified:

How to display those mailboxes that exceed quotas in zimbra server?

This is using zimbra collaboration suite 6.0.8. I want to a list of those mailboxes that exceed the quota. How can I get the report?
0
Balack
Asked:
Balack
  • 5
  • 3
1 Solution
 
MCode151Commented:
zmprov gqu localhost | awk '$3 > $2'
0
 
MCode151Commented:
*gqu=getQuotaUsage
0
 
BalackAuthor Commented:
Hi MCode151, I can get the list of mailboxes, for example, usera@abc.com 0 4616. What does 0 and 4616 stands for?
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
MCode151Commented:
The default order is acctName1 quotaAlloted2 currentUsage3 in bytes.

0=unlimitedQuota

doing the pipe awk mentioned above should spit out any accts who's column 3 is greater than column 2 aka over quota.

There's warning emails at 90% by default (see cos or acct > advanced) or here's some scripts for on demand:
http://wiki.zimbra.com/wiki/Quota_Warnings
http://wiki.zimbra.com/wiki/Quota_Warning_Script

There's even a handy attribute zimbraMailAllowReceiveButNotSendWhenOverQuota
0
 
MCode151Commented:
*zimbraMailAllowReceiveButNotSendWhenOverQuota went into ZCS 7.0
0
 
BalackAuthor Commented:
Hi MCode151,

  By running zmprov gqu localhost | awk '$3 > $2', I get 50+ mailboxes that without quote, because the quote limit is '0'. I should check those mailboxes that have 90% filled. By the way, how to have a list of those mailboxes that with 90% filled?
0
 
billmercerCommented:
Looks to me like the original question was answered quite well. Points should go to MCode151 IMO.


Multiply $2 by 0.9 to get the 90% quota, but that's not going to do any good if everyone is unlimited.

0
 
MCode151Commented:
Yup, this command should show you anyone with a fixed quota that's greater than 90%:

zmprov gqu localhost | awk '$2 > 0 && $3 > 0.9*$2'

Notice by using && (the and operator) we're checking for those greater than zero first, to exclude the unlimited ones.

There's also a section in the admin console for this. https://server.domain.com:7071 > server statistics > server (much like sessions have to select the individual server since it's not in global yet) > 'mailbox quota' tab, and you can sort the columns either direction.
0
 
BalackAuthor Commented:
Excellence
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 5
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now