Brad,
Hello, my msgs table does not contain an 'email' column, and I don't see it
in the mysql readme schema either.
It is a field in table mailaddr.
Tables msgs and msgrcpt contain a reference (sid or rid) to an
e-mail address, which is stored in full in table mailaddr.
Is it ok to add this
Thanks Mark,
This was what I looked for.
Regards
Peter
-Oprindelig meddelelse-
Fra: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] På vegne af Mark Martinec
Sendt: 12. august 2008 15:56
Til: amavis-user@lists.sourceforge.net
Emne: Re: [AMaViS-user] Advice on SQL to extract
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
Hi,
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
On Fri, August 8, 2008 14:07, Peter Sørensen wrote:
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