Re: drop in graph??

2005-06-02 Thread Ronan McGlue

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   spamrej FN  FP  Vir
2005-04-03: 18615   11776   4445163 0   93
2005-04-04: 20920   10750   520673  0   131
2005-04-05: 19325   9368541270  0   150
2005-04-06: 22396   11259   580386  0   95
2005-04-07: 20741   8981649975  0   116
2005-04-08: 23526   12300   6222120 0   115
2005-04-09: 21856   14664   6489128 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??

2005-06-01 Thread Fred
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??

I use MIMEDefang with GraphDefang, it's easy to add your own graph features,
I recommend it!



Re: drop in graph??

2005-05-30 Thread Paul Boven

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   spamrej FN  FP  Vir
2005-04-03: 18615   11776   4445163 0   93
2005-04-04: 20920   10750   520673  0   131
2005-04-05: 19325   9368541270  0   150
2005-04-06: 22396   11259   580386  0   95
2005-04-07: 20741   8981649975  0   116
2005-04-08: 23526   12300   6222120 0   115
2005-04-09: 21856   14664   6489128 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??

2005-05-30 Thread Mike Jackson
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. 



Re: drop in graph??

2005-05-30 Thread E. Falk
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


drop in graph??

2005-05-30 Thread Ronan McGlue
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
--


Regards

Ronan McGlue
Info. Services
QUB