You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@spamassassin.apache.org by "E. Falk" <bs...@directrans.com> on 2005/05/30 15:56:23 UTC
Re: drop in graph??
I'm sure there are some PHP hackers who have much nicer graphs than I
do, but I found the easiest thing to do was to extract numbers from my
logs with some perl scripts and paste them into Excel. Management likes
Excel and it makes pretty charts. :)
It's not automated, but it does have lots of primary colours.
Evan
Ronan McGlue wrote:
> is there an 'easy' way to get a grpahical representation of how well SA
> is doing??
> preferably something flashy with lots of primary colours for the
> managment elite??
>
> if not i suppose i gotta start hackin rrdtool scripts or similar!!?
>
>
> mnay thanks
>
> Ronan
Re: drop in graph??
Posted by Ronan McGlue <r....@qub.ac.uk>.
Paul Boven wrote:
> Mike Jackson wrote:
>
>>> I'm sure there are some PHP hackers who have much nicer graphs than I
>>> do, but I found the easiest thing to do was to extract numbers from
>>> my logs with some perl scripts and paste them into Excel. Management
>>> likes Excel and it makes pretty charts. :)
>>>
>>> It's not automated, but it does have lots of primary colours.
>>
>>
>>
>> You can save yourself a lot of time with the Spreadsheet::WriteExcel
>> CPAN module. I don't know if you can use it to make the charts and
>> graphs, but at least you can have it write out the data.
>
>
> Instead of making a spreadsheet, how about a bit of gnuplot?
>
> Input: (generated by some overly complicated script-magic I don't dare
> share in here)
>
> #date recvd spam rej FN FP Vir
> 2005-04-03: 18615 11776 4445 163 0 93
> 2005-04-04: 20920 10750 5206 73 0 131
> 2005-04-05: 19325 9368 5412 70 0 150
> 2005-04-06: 22396 11259 5803 86 0 95
> 2005-04-07: 20741 8981 6499 75 0 116
> 2005-04-08: 23526 12300 6222 120 0 115
> 2005-04-09: 21856 14664 6489 128 1 91
> ^ Uhoh...
>
> gnuplotrc:
>
> set terminal png small color picsize 800 500
> set output 'spamstats.png'
> set format x '%Y-%m-%d'
> set key outside
> set xdata time
> set timefmt "%Y-%m-%d"
> set xtics rotate
> set xtics 86400
> plot 'bayes.log' using 1:2 title ' received' with linespoints, \
> 'bayes.log' using 1:3 title 'spam' with linespoints, \
> 'bayes.log' using 1:4 title ' rejected' with linespoints, \
> 'bayes.log' using 1:($5+$6) title 'false' with linespoints, \
> 'bayes.log' using 1:7 title 'virus' with linespoints
> set output 'percentage.png'
> plot 'bayes.log' using 1:(100*$5/($2)) title ' %falseneg' with
> linespoints, \
> 'bayes.log' using 1:(100*$6/($2)) title ' %falsepos' with
> linespoints
>
>
> And then it's just 'gnuplot gnuplotrc' and presto, pretty pictures.
>
> Regards, Paul Boven.
i like it... thanks i was gonna go rrdtool but i like the looks of this.
but why isnt your "complicated script-magic I don't dare share in here"
GNU public licesnce????
;)
ronan
--
========
Regards
Ronan McGlue
Info. Services
QUB
Re: drop in graph??
Posted by Paul Boven <p....@chello.nl>.
Mike Jackson wrote:
>> I'm sure there are some PHP hackers who have much nicer graphs than I
>> do, but I found the easiest thing to do was to extract numbers from my
>> logs with some perl scripts and paste them into Excel. Management
>> likes Excel and it makes pretty charts. :)
>>
>> It's not automated, but it does have lots of primary colours.
>
>
> You can save yourself a lot of time with the Spreadsheet::WriteExcel
> CPAN module. I don't know if you can use it to make the charts and
> graphs, but at least you can have it write out the data.
Instead of making a spreadsheet, how about a bit of gnuplot?
Input: (generated by some overly complicated script-magic I don't dare
share in here)
#date recvd spam rej FN FP Vir
2005-04-03: 18615 11776 4445 163 0 93
2005-04-04: 20920 10750 5206 73 0 131
2005-04-05: 19325 9368 5412 70 0 150
2005-04-06: 22396 11259 5803 86 0 95
2005-04-07: 20741 8981 6499 75 0 116
2005-04-08: 23526 12300 6222 120 0 115
2005-04-09: 21856 14664 6489 128 1 91
^ Uhoh...
gnuplotrc:
set terminal png small color picsize 800 500
set output 'spamstats.png'
set format x '%Y-%m-%d'
set key outside
set xdata time
set timefmt "%Y-%m-%d"
set xtics rotate
set xtics 86400
plot 'bayes.log' using 1:2 title ' received' with linespoints, \
'bayes.log' using 1:3 title 'spam' with linespoints, \
'bayes.log' using 1:4 title ' rejected' with linespoints, \
'bayes.log' using 1:($5+$6) title 'false' with linespoints, \
'bayes.log' using 1:7 title 'virus' with linespoints
set output 'percentage.png'
plot 'bayes.log' using 1:(100*$5/($2)) title ' %falseneg' with
linespoints, \
'bayes.log' using 1:(100*$6/($2)) title ' %falsepos' with
linespoints
And then it's just 'gnuplot gnuplotrc' and presto, pretty pictures.
Regards, Paul Boven.
Re: drop in graph??
Posted by Mike Jackson <mj...@barking-dog.net>.
> I'm sure there are some PHP hackers who have much nicer graphs than I do,
> but I found the easiest thing to do was to extract numbers from my logs
> with some perl scripts and paste them into Excel. Management likes Excel
> and it makes pretty charts. :)
>
> It's not automated, but it does have lots of primary colours.
You can save yourself a lot of time with the Spreadsheet::WriteExcel CPAN
module. I don't know if you can use it to make the charts and graphs, but at
least you can have it write out the data.