• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Question Export Emails with details

ToxicVerbid

New Pleskian
Hey guys,

Does anyone have or know a MySQL command to extract all e-mail address, passwords which then state the forwarder(s) and alias for the account?
 
Try something like this

mysql> select mail_name,redirect,redir_addr,name,password from mail left join domains on mail.dom_id = domains.id inner join accounts where mail.account_id = accounts.id and postbox='true' order by name asc, mail_name asc;
 
Back
Top