Here is a command for main server to show all websites... and service, staging etc. too, not only live domains.
sudo -u postgres psql -X -P pager=off -d orchd -c "SELECT COALESCE(string_agg(DISTINCT d.domain, ', '), w.id::text) AS domains, w.kind, COALESCE(w.php_version,'(none)') AS php, COALESCE(NULLIF(s.friendly_name,''),s.hostname) AS server FROM websites w JOIN servers s ON s.id=w.server_id LEFT JOIN domain_mappings dm ON dm.website_id=w.id LEFT JOIN domains d ON d.id=dm.domain_id WHERE w.soft_deleted_at IS NULL GROUP BY w.id, w.kind, w.php_version, s.friendly_name, s.hostname ORDER BY php, domains;"
