Exporting blacklist/whitelist

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) type the correct query:

select * from senders where SndAuthorized = 0 

(for exporting whitelist use SndAuthorized = 1)

For exporting the blacklist of one user, type 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