How to get a list of all domains from which are using a specific PHP handler in Plesk via command line?

Follow

Comments

3 comments

  • Avatar
    Brian Craigie

    Number 5 is great, but could be improved by excluding domains that are currently disabled and also to exclude those that are aliases. :-)

    1
    Comment actions Permalink
  • Avatar
    Brian Craigie

    Number 5 can be improved thus:

    plesk db "select domains.name, dom_id, php, php_handler_id, fastcgi, WebServerSettingsParameters.value as 'Served as nginx?' from hosting JOIN domains on domains.id=hosting.dom_id JOIN WebServerSettingsParameters on WebServerSettingsParameters.webServerSettingsId=(select val from dom_param WHERE param='webServerSettingsId' AND dom_id=domains.id) where WebServerSettingsParameters.name='nginxServePhp' AND domains.status=0"

    1
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello Brian

    Thank you for the notice!

    I will pass it to the article author.

    1
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request