On Apr 28, 2010, at 4:46 PM, Michael Scheidell wrote: > > On 4/28/10 10:37 AM, Jernej Porenta wrote: >> 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? >> >> > anything in the msgs table was sent through amavisd. > You might write a sql query that does a double join on msgs, msgrcpt, > and maddr to get everything you want.
I am looking for emails that were sent through spam scanner in amavis (SA), not just amavis. This means that I need to find out which emails were spam scanned and which weren't (by setting bypass_spam in policy). I could do analyze logs for this, but it would be way more appropriate using SQL, but I dont know whether this information is actually stored in SQL or not. 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/
