Exporting blacklist/whitelist

Posted by Ondrej Vanek, Last modified by Ondrej Vanek on 11 December 2015 08:33 AM

To export all blacklisted addresses from your database via IceWarp Server Administration console:

1) connect the integrated SQL Manager with your Anti-Spam database

2) write your appropriet query:

select * from senders where SndAuthorized = 0 

(for exporting whitelist use SndAuthorized = 1)

For exporting blacklist of one user write this query:

select * from senders where SndAuthorized = 0 and SndOwner = 'user@domain.net'   

(for filtering whole domain use SndDomain instead of SndOwner)

3) execute the query

4) export the query and save it as csv file on your file-system

                                                                                                                                                                                 © o.vanek