Date: Wed, 17 Feb 1999 18:47:20 +1100
From: "Tony-Farr (Canberra)" <Tony.Farr@austrade.gov.au>

This script extracts summary figures from the MRTG log files. In particular
it summarises all sites (i.e. as many as will fit on a page) into a single
Excel chart.

The summary is placed in an Excel spreadsheet & chart. The Excel worksheet
will have the same name as this program & be placed in the MRTG log file
directory.

I wrote this to summarise ping round trip times as generated by 
"mrtg-ping-probe". However it will process any mrtg log file. Some formatting
type stuff would need to be changed though if it were to be used for things
other than ping response times.

If, like us, you use PWS/IIS & IE, you can just link to the spreadsheet and
read it with IE.

A trap for novices:
If you have problems running Excel from "at", it's probably because of a
bug/limitation in "at". The problem is that regardless of which user submits
the job, it gets executed by the "system" user. (Great security, huh?) However
Excel probably isn't installed for the user "system". I changed the schedule
service to run as me rather than "system".

Args are:
	h	help
	d,w,m	do stats for last day, week or month
	f	directory containing mrtg log files

For example, once a week I run a CMD file that includes:

perl c:\perl\mrtg\contrib\xlsummary\xlsummary.pl -w -f d:\www\mrtg\ping
del d:\www\mrtg\ping\weeksummary.xls
ren d:\www\mrtg\ping\xlsummary.xls weeksummary.xls


Feel free to contact me regarding bugs.
Tony.Farr@austrade.gov.au