[rules.analysis.sh]

[nicola.piazzi]

This simple script create a csv file that can be pasted in an Excel file (rules.analysis.xlsx) to have a report of Score Hits so you can easly made score adjustments.

Put rules.analysis.sh in the folder that you want
Review 4 Parameters editing it (Mysql root password, Spam score threshold, Days to analyze from now, Spam score threshold)
Launch the script (it take several hours to run)
At the end copy resulted rules.analysis.csv and paste in csv folder of rules.analysis.xlsx

[ovizii]

How does this differ from what I can see going to EFA => Reports (setting up my filters) => SpamAssassin Rule Hits?

[nicola.piazzi]

Difference is that is in csv format and that it give spam/ham hits using a relative threshold

for example if a rule score of 2 in my script i count spam and ham not with threshold 4 but 4 + 2 so re