Solved

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

Posted on 2011-02-23
11
2,900 Views
Last Modified: 2012-05-11
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
Comment
Question by:Balack
  • 5
  • 3
11 Comments
 
LVL 5

Expert Comment

by:MCode151
ID: 34961535
zmprov gqu localhost | awk '$3 > $2'
0
 
LVL 5

Expert Comment

by:MCode151
ID: 34961549
*gqu=getQuotaUsage
0
 

Author Comment

by:Balack
ID: 34962286
Hi MCode151, I can get the list of mailboxes, for example, usera@abc.com 0 4616. What does 0 and 4616 stands for?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 5

Expert Comment

by:MCode151
ID: 34962930
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
 
LVL 5

Expert Comment

by:MCode151
ID: 34962950
*zimbraMailAllowReceiveButNotSendWhenOverQuota went into ZCS 7.0
0
 

Author Comment

by:Balack
ID: 34966956
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
 
LVL 19

Expert Comment

by:billmercer
ID: 35039051
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
 
LVL 5

Accepted Solution

by:
MCode151 earned 500 total points
ID: 35039193
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
 

Author Closing Comment

by:Balack
ID: 35050413
Excellence
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We are happy to announce a brand new addition to our line of acclaimed email signature management products – CodeTwo Email Signatures for Office 365.
Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question