Plesk domain database status code

Active Domains - Status code 0
Domain in backup/restore State - Status code 4
Expired Domains - Status code 256
Suspended Domain - Status code 64



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'