Applicable to:
- Plesk Onyx for Linux
Question
How to get a list of subscriptions without subdomains, aliases and additional domains?
Answer
-
Connect to the server via SSH .
-
Execute the following command:
# plesk db "select name from domains where id not in (select d.id from domains d, domains d2 where d2.parentDomainId=d.id) and parentDomainId=0 and id not in (select d.id from domains d, domains d2 where d2.webspace_id=d.id) and webspace_id=0 and id not in (select domains.id from domains left join domain_aliases on domains.id=domain_aliases.dom_id where domain_aliases.dom_id<>0);"
Comments
0 comments
Please sign in to leave a comment.