Spam-Filter Einstellungen prüfen via SQL

In diesem Artikel:

Kategorie: Plesk Tags: SQL

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;