mendozal Is there some CLI command to quickly check all php versions used by websites?
You can use this command to list all primary domains along with their PHP versions and the server they're hosted on:
sudo -u postgres psql -X -P pager=off -d orchd -c "SELECT d.domain, 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 JOIN domain_mappings dm ON dm.website_id=w.id AND dm.kind='primary' JOIN domains d ON d.id=dm.domain_id WHERE w.kind=0 AND w.soft_deleted_at IS NULL ORDER BY php, d.domain;"
Alternatively, you can find the same information in your cPFence webui > Tools & Utilities, where you can also use bulk actions to change PHP versions across multiple websites quickly.
