How to find Plesk domains exceeding disk quota?

• Plesk 11.x Linux

To perform this task, you need to have :

• Knowledge in accessing the server via SSH.
• IP address or server hostname.
• Your server SSH username and password.

1.    Login via SSH as the root user.

2.    Access MySQL as the admin user by execute below command on terminal

mysql  -uadmin -p`cat /etc/psa/.psa.shadow`

3.    Tell MySQL you want to use the Plesk Database psa:

use psa;

4.    Execute the following MySQL Query:

SELECT domains.name, domains.real_size, Limits.value FROM domains, Limits WHERE domains.limits_id = Limits.id AND domains.real_size > Limits.value AND limit_name = 'disk_space' AND Limits.value != -1 ORDER BY domains.name ASC;

5.    You should now get a table output containing a list of all of the domains within Plesk which have exceeded the mail quota.

6.    To quit MySQL simply type exit.

Please refer to the following article to know more.
Knowledge Base: Plesk Backup Manager: Guide to Safeguarding Your Server Data