Der folgende Befehl zeigt die SPAM-Filter Einstellungen aller Postfächer auf dem Plesk-Webserver an.
- Über die Shell (bspw. mit PUTTY) mit dem Webserver verbinden.
- Nach der Anmeldung folgenden Befehl eingeben.
plesk db
Jetzt kann der SQL-Befehl reinkopiert und mit Enter ausgeführt werden.
Alle E-Mail-Adressen mit Postfach und SPAM Filter Einstellungen
SELECT
DISTINCT CONCAT(mail.mail_name, '@', domains.name) AS mailbox,
mail.postbox,
mail.spamfilter,
ACTION.preference AS 'ACTION',
ACTION.value AS 'ACTION-VALUE',
REQUIRED_SCORE.preference AS 'REQUIRED_SCORE',
REQUIRED_SCORE.value AS 'REQUIRED_SCORE-VALUE',
REWRITE_HEADER.preference AS 'REWRITE_HEADER',
REWRITE_HEADER.value AS 'REWRITE_HEADER-VALUE',
domains.name
FROM mail
LEFT JOIN mail_redir ON mail_redir.mn_id = mail.id
LEFT JOIN domains ON domains.id = mail.dom_id
LEFT JOIN spamfilter
ON spamfilter.username = CONCAT(mail.mail_name, '@', domains.name)
LEFT JOIN spamfilter_preferences AS ACTION
ON ACTION.spamfilter_id = spamfilter.id
AND ACTION.preference = 'action'
LEFT JOIN spamfilter_preferences AS REQUIRED_SCORE
ON REQUIRED_SCORE.spamfilter_id = spamfilter.id
AND REQUIRED_SCORE.preference = 'required_score'
LEFT JOIN spamfilter_preferences AS REWRITE_HEADER
ON REWRITE_HEADER.spamfilter_id = spamfilter.id
AND REWRITE_HEADER.preference = 'rewrite_header'
WHERE mail.postbox = 'true'
ORDER BY mail.postbox ASC, domains.name ASC;
plesk db 
Anzeige des Ergebnisses als Tabelle