Plesk domain status codes

[Vinil]

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