Heya, I was wondering whether there is a way to find out with SQL query from amavis database, which emails were sent through SA and which were not. I know that it depends on the policy, but is there a way to combine policy with msgs table?
Filtering out spam_level = 0 is not the way, since some of the emails might get the score 0. policy field in msgs table is not representing the policy used for email, so the only way that I can think of is, parsing the logs for 'Hits: -,' and combining results from SQL. Since Mark is on vacation, does anyone knows how to get this information? thank you in advance, regards, Jernej ------------------------------------------------------------------------------ _______________________________________________ AMaViS-user mailing list AMaViS-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
