List all active domains:
SELECT name FROM domains WHERE status = '0'
List all suspended domains:
SELECT name FROM domains WHERE status != '0'
List all expired (hosting) domains:
SELECT name FROM domains WHERE status = '256'
List all domains with backup/restore in progress:
SELECT name FROM domains WHERE status = '4'
List all domains suspended by client:
SELECT name FROM domains WHERE status = '64'
Connect to Plesk mysql database:
#mysql -uadmin -p 'cat /etc/psa/.psa.shadow' -Dpsa