Plesk domains exceeding quotas

[Vinil]

Find domains that are over quota on disk space in Plesk:


mysql>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;