- Plesk Onyx for Linux
How to get a list of all subscriptions with mailist ?
1. Connect to the server via SSH.
2. Use the following command to get list of all subscriptions with active mailing lists:
# plesk db 'SELECT domains.name as "Domain name", MailLists.name as "Mail list name",MailLists.status as "Maillist status: 0 - enabled, 1 - switched off" FROM domains, MailLists WHERE domains.id = MailLists.dom_id;'