• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3277
  • 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
[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

 
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

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