Retrieving Web Users and Passwords from Plesk

To get a list of uid's and passwords for web users run the following query:

SELECT su.login AS "Web User", a.password AS "Password"
FROM web_users AS wu
JOIN sys_users AS su ON wu.sys_user_id =
JOIN accounts AS a ON su.account_id =
JOIN domains AS d ON wu.dom_id =