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.
--
Michael Scheidell, CTO
Phone: 561-999-5000, x 1259
> *| *SECNAP Network Security Corporation
* Certified SNORT Integrator
* 2008-9 Hot Company Award Winner, World Executive Alliance
* Five-Star Partner Program 2009, VARBusiness
* Best Anti-Spam Product 2008, Network Products Guide
* King of Spam Filters, SC Magazine 2008
______________________________________________________________________
This email has been scanned and certified safe by SpammerTrap(r).
For Information please see http://www.secnap.com/products/spammertrap/
______________________________________________________________________
------------------------------------------------------------------------------
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
