[SOLVED] Get amavis_msg_count/amavis_spam_count

[jor-el]

Hi, we are looking to customize our spam filters(adding SPF, tuning spamassassin configuration files, etc.), but we need to see if what we're doing is actually working, we need to see the numbers, not just the graphics, is there any way to get the amavis_msg_count and amavis_spam_count from the CLI(or any other way but to get the real number)?.

Thanks!

[uxbod]

Postfix and Amavis Log Reporters

You will need to increase log_level to 2 in /opt/zimbra/conf/amavisd.conf.in and then run

su - zimbra
zmamavisdctl stop ; zmamavisdctl start

[jor-el]

Hello uxbod, that is just the tool i needed, even whit the log level set to 1 it parses the info I needed, of course there's no detailed information, so it's not that usefull for identifing patterns or anything, but to get a summary from the data that we already have still works, I already increased the log level to make amavis-logwatch reports more rich.

Thank you very much!

Best Regards

[jor-el]

Just in case anyone reads this in the future(this can be helpfull), there is also a way to see simple information in the mysql database:

as zimbra user(su - zimbra) run logmysl - D zimbra_logger (the -D parameter is optional just to avoid having to change databases inside the DBMS).

Under the table amavis_aggregate you have the sumary of the message count, the spam count, and the virus count, by hour, or by day.

If you are interested in more detailed information you can query the amavis table. There are other tables such as config, mta or mta_aggregate that may interest you, but, be carefull whit this.

Regards,