Plesk domain database status code

by rajesh 2012-04-19 10:17:32

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'

Tagged in:

644
like
0
dislike
0
mail
flag

You must LOGIN to add comments