How to list all domain names via CLI?

Question

How to list all domain names via the command line interface?

Answer

One can use the following command to list all domain names:

# plesk bin site --list

Alternatively, one can extract those via the database with this command:

# plesk db "SELECT name FROM domains;"

In order for the list to include all domain aliases, please use the command below instead:

# plesk db "SELECT name FROM domains UNION SELECT name FROM domain_aliases"