plesk guide

Plesk How-To: Export List of all Mail Aliases

Plesk stores most of its information in the psa database, so getting information out can usually be done via an SQL query. To export a list of all mail aliases sorted alphabetically grouped by domain, run the SQL query below: select concat(mail_aliases.alias,’@’,domains.name) as aliases from mail,mail_aliases,domains where mail.dom_id=domains.id and mail_aliases.mn_id=mail.id order by domains.name; If you

Plesk How-To: Export List of all Mail Aliases Read More »

Plesk How-To: Export List of Mail-enabled Domains

Plesk stores most of its information in the psa database, so getting information out can usually be done via an SQL query. To export a list of all domains with emails enabled, run the SQL query below: select distinct domains.name from mail,domains where mail.dom_id=domains.id order by name; If you want to store the output in

Plesk How-To: Export List of Mail-enabled Domains Read More »