Peter,
> Not being an expert in SQL I ask here. I use amavisd-new 2.6.1 and do Mysql
> quarantine.
>
> I would like to generate a daily report based on the recipients
> which contains the mail_id and secret_id for mail quarantined as SPAM.
>
> Just to make a simple report containing links, where users can release
> their mail.
Something like the following (the time interval is to be improved):
SELECT email,mail_id,secret_id,subject FROM msgs
JOIN msgrcpt USING (partition_tag,mail_id)
JOIN maddr ON (msgrcpt.partition_tag=maddr.partition_tag
AND msgrcpt.rid=maddr.id)
WHERE content='S' AND quar_type<>' '
AND time_iso < now() - INTERVAL '1 day'
ORDER BY time_num DESC;
Mark
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
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/
