export the email accounts in Plesk into a CSV file

[Sandar Min Aye]

Hi All,

I am using the Plesk 12 in windows server 2008.
I want to export the email accounts in Plesk into a CSV file.
Could you kindly give me the ways?

Thanks.

 

[IgorG]

You can get list of emails from psa database with following SQL query at least:

mysql> select concat(mail.mail_name,"@",domains.name) as address from mail,domains,accounts where mail.dom_id=domains.id and mail.account_id=accounts.id order by address;