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 = '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

 

 export

                                                                                                                                                                                 © o.vanek

 

(7 vote(s))
Helpful
Not helpful

Comments (0)