DE

↑ ↓ select, Enter open, Esc close

List all email addresses on a Plesk server

harmless rootPleskdebian, ubuntu
root@server
plesk db "SELECT CONCAT(m.mail_name, '@', d.name) AS adresse, m.postbox FROM mail m JOIN domains d ON d.id = m.dom_id ORDER BY d.name, m.mail_name"

Reads all mail addresses directly from the Plesk database psa and prints them as a table. The postbox column shows whether the address has a mailbox or only forwards. Useful for inventories and migration planning.

Also searched as

  • show all email addresses on server plesk
  • export plesk mailboxes
  • which email accounts exist plesk

Related one-liners

All in Plesk

Change the password of a Plesk mailbox

#plesk bin mail --update info@example.com -passwd 'NewSecurePassword'
cautionPlesk

Check the mail configuration in Plesk without changes

#plesk repair mail -n
harmlessPlesk

Check the Plesk database for inconsistencies

#plesk repair db -n
harmlessPlesk

Create an email mailbox in Plesk from the command line

#plesk bin mail --create info@example.com -mailbox true -passwd 'NewSecurePassword'
cautionPlesk

Find the system user of each domain in Plesk

#plesk db "SELECT d.name, s.login FROM domains d JOIN hosting h ON h.dom_id = d.id JOIN sys_users s ON s.id = h.sys_user_id ORDER BY d.name"
harmlessPlesk

List all databases with their domain in Plesk

#plesk db "SELECT d.name AS domain, db.name AS datenbank, db.type FROM data_bases db JOIN domains d ON d.id = db.dom_id ORDER BY d.name, db.name"
harmlessPlesk

Read first, then run.

The commands on myline.de act directly on servers, files and databases. A wrong path or placeholder can delete data irreversibly or make a server unreachable.

  • All commands are provided without warranty and are not tested on every system.
  • Understand what a command does before running it, and check every placeholder.
  • Make a backup first and, if possible, try it on a test system.
  • You run commands at your own risk. Liability for damages is excluded to the extent permitted by law.