Plesk Database Queries
Last 20 Actions in Plesk
SELECT log_actions.date, log_actions.ip_address, log_actions.user, log_components.component, log_components.old_value, log_components.new_value FROM log_actions LEFT JOIN log_components ON log_actions.id = log_components.action_id ORDER BY log_actions.date DESC LIMIT 20;
Domain, Hosting Type, www_root, PHP Handler, Login, Webspace ID
SELECT domains.id,domains.name,domains.htype,hosting.www_root,hosting.php_handler_type,sys_users.login,webspace_id from psa.domains join psa.hosting on psa.hosting.dom_id=psa.domains.id join psa.sys_users on psa.sys_users.id=psa.hosting.sys_user_id;