Knowledgebase: Technical Help
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 = ''   

(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


(7 vote(s))
Not helpful

Comments (0)