DE

↑ ↓ select, Enter open, Esc close

Read hosting type and status of all domains from the Plesk database

harmless rootPleskdebian, ubuntu
root@server
plesk db "SELECT name, htype, status FROM domains ORDER BY name"

Prints all domains with their hosting type (vrt_hst for web hosting, std_fwd and frm_fwd for forwarding, none for no hosting) and status. Status 0 means active, other values stand for suspended or disabled domains.

Also searched as

  • find suspended domains plesk
  • show domains without hosting
  • plesk domain status overview

Related one-liners

All in Plesk

Change the PHP version of a domain from the command line

#plesk bin domain --update example.com -php_handler_id plesk-php83-fpm
cautionPlesk

Check the Plesk database for inconsistencies

#plesk repair db -n
harmlessPlesk

Create a domain alias in Plesk from the command line

#plesk bin domalias --create example.de -domain example.com
cautionPlesk

Find the system user of each domain in Plesk

#plesk db "SELECT d.name, s.login FROM domains d JOIN hosting h ON h.dom_id = d.id JOIN sys_users s ON s.id = h.sys_user_id ORDER BY d.name"
harmlessPlesk

List all databases with their domain in Plesk

#plesk db "SELECT d.name AS domain, db.name AS datenbank, db.type FROM data_bases db JOIN domains d ON d.id = db.dom_id ORDER BY d.name, db.name"
harmlessPlesk

List all domains of a Plesk subscription

#plesk db "SELECT d.name FROM domains d LEFT JOIN domains p ON p.id = d.webspace_id WHERE d.name = 'example.com' OR p.name = 'example.com' ORDER BY d.name"
harmlessPlesk

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.