Plesk: view all email accounts

Published by exdone

Posted on March 15, 2009

mysql query
select CONCAT(mail_name,”@”,name) as email_address,accounts.password from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;

Thanks to RackerHacker

DBname normally : psa

Categories: Plesk