Show subscriptions PHP versions and handlers

[masterdam79]

For a client I need to produce an overview which subscriptions are using which PHP handler/version.
AFAICS there is no such posibility in any bin in /usr/local/psa/bin/ or /usr/local/psa/admin/bin/ or the Plesk Web user interface.
Googling led me nowhere.

I assume I'd have to create some custom query on the psa database?

 

[IgorG]

You can find this information in 'hosting' table. For example:

mysql> select dom_id,www_root,php_handler_id from hosting;
+--------+---------------------------------------------------+----------------+
| dom_id | www_root | php_handler_id |
+--------+---------------------------------------------------+----------------+
| 1 | /var/www/vhosts/ppu12-0.demo.pp.plesk.ru/httpdocs | fastcgi |
+--------+---------------------------------------------------+----------------+
1 row in set (0.00 sec)

 

[masterdam79]

Igor, thanks for your reply.
One step forward in the right direction.
I was simultaniously looking for the PHP version to be listed.
For example, under fastcgi we have PHP 5.4 and PHP 5.5 and I'd need to know which subscription is running which PHP version as well.
At least I can filter the (apache_)module/mod_php with PHP 5.3 now, thanks!

 

[masterdam79]

Never mind!
The php_handler_id is a unique value representing the handler and version.