Applies to :

  • Plesk 11.x Linux

Requirements

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.

Instructions

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.