Find Plesk domains exceeding quotas

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

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;

Related documentation