I kept working on my spreadsheet to use for reporting, and have finally finished it. I made it so that it should be able to be used by anyone...and it has a chronological listing of all monitored events, and some very pretty charts to show the boss. I went this route, because I anticipate I will be using it to run the results of several different installations of SA.
It now handles 5000 lines of log output, and it is user configurable for your use, you don't have to edit any formulas, nor do any cutting and pasting, it is all automatically done for you, the file is rather large, and if you have limited space, that could be a bit of a problem. You can download the spreadsheet and setup instructions from my web server at http://www.ptgeek.isa-geek.com/report/ Let me know what you think. Jonathan Marsden -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jonathan Marsden Sent: Friday, August 08, 2003 3:21 PM To: [EMAIL PROTECTED] Subject: RE: [SA-list] Statistical logging output to those of you having difficulty hitting the file, try http://ptgeek.isa-geek.com/report/ that should show a directory with the file. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jonathan Marsden Sent: Friday, August 08, 2003 3:06 PM To: [EMAIL PROTECTED] Subject: RE: [SA-list] Statistical logging output BTW... If anyone else wants to take a look at the excel spreadsheet for reports, I slapped it up on a public directory on my web server, http:/ptgeek.isa-geek.com/report/report.xls it is a big honkin' file (10MB) because it is formatted to handle up to 10,000 lines of log file output at a shot, you can shorten it if you want. I am still working on it, so this is preliminary stuff. Instructions are fairly basic: 1. Go into the setup for the statistical file in SA, and set the output file to ".csv", and set the reporting format to "seconds". 2. SA will only make entries to the stat log when something changes, and the output will be something like "Server,1,1,5,20030807,0906,20030807,0505,4". When you open the .csv log file, open it with excel, which will create a kind of a basic excel spreadsheet with no formatting or anything. 3. Do a "select" and "copy" of ONLY the cells in the csv spreadsheet with data in them, open the report.xls file, and go to sheet three, cell "A4" and then paste. 4. Other cells in page three will immediately be populated based on the data you pasted in. These are the translation cells with the embedded formulas in them. 5. Go to sheet 2 of the workbook, and there is your basic report. state changes are in verbose, just read, time duration in a down state should show up in red, Up state in black. I left sheet one in place, to cut and past data from the report to sort it by device, play around with it. 6. To reuse the spreadsheet, just go to the yellow section in sheet three, and do a highlight, right click, "clear contents", it will remove all the data, without killing any formulas. 6. Most of the workbook is in "protected sheet" mode, and I don't think you have to change it at all, but I left it in blank password mode if you want to play with it. During actual use, keep it protected, it keeps you from overwriting the rather interesting formulas I wrote to change the date format, and translate the "state" codes. The sheet is setup to take up to 10,000 lines of entries, so unless you are running a huge operation, you should be ok, but it is a simple matter to just unprotect it and add another 10,000 lines to it by special pasting the formulas in. Because the spreadsheet is protected, it doesn't allow for import of data from a txt or csv file, but cutting and pasting is just as quick. BTW, in case you don't know what the info in the statistical file output means, here is a key: |Pretty Name|,|UID|,|Current State|,|Former State|,|Date of last check|,|Time of last check|,|Previous change date|,|previous change time|,|time differential between state changes| If any of you have any suggestions, please let me know, I am working on adding sheets that will filter by device, and include bar or pie charts to show device availability...and let me know what you think. Jonathan Marsden -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Bradshaw Sent: Friday, August 08, 2003 10:51 AM To: [EMAIL PROTECTED] Subject: RE: [SA-list] Statistical logging output Robert, try running your script using the interchange function. That way it will run after the check cycle. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Robert Haerkens / Native networks > Sent: Friday, August 08, 2003 9:50 AM > To: [EMAIL PROTECTED] > Subject: [SA-list] Statistical logging output > > > Hello Jonathan, > > I also created a very small tool to convert the statistical file to > HTML. I wrote it in simple VBS and run it as a external check. The VBS > script reads the statistical data and converts the status-values to text > (UP, DOWN, etc.). It also creates a HTML table. It only is a pitty that > the statistical file is updated *after* the last check. So the tool will > always report one cycle later. > > Because I wanted to split the statistical file by sub-test I first call > a normal batch file which searches the statistical file for keywords. > All together it looks like this: > ---------------------------------------------------------------- > copy *.log statistics.csv (combine all the logfiles) > > find /i "mailserver" statistics.csv > st_mailserver.csv > find /i "proxyserver" statistics.csv > st_proxy.csv > > stat2html.vbs st_mailserver.csv st_mailserver.html > stat2html.vbs st_proxy.csv st_proxy.html > > Call do_ftp.cmd > ---------------------------------------------------------------- > > If you want a copy of these files (to change it for your own use) just > mail me. > > Kind regards, > > Robert > > > -----Oorspronkelijk bericht----- > Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Namens > Jonathan Marsden > Verzonden: vrijdag 8 augustus 2003 15:34 > Aan: [EMAIL PROTECTED] > Onderwerp: RE: [SA-list] Suggestion > > > Dear Dirk, > > I went looking in the list archives for a simple utility that will give > some sort of readable reporting from the statistical reports, and saw > that there were a few others out there looking for the same thing...I > don't run a SQL server, and don't have a lot of experience with access. > I wanted something that would give me basic up/down and elapsed time > reports. I couldn't find anything, of course, so I created an excel > spreadsheet that does some pretty basic translation of the logs. If > there is anyone out there that wants a copy, they are welcome to email > me. > > Jonathan Marsden > Part-Time Geeks Computer services > www.ptgeek.isa-geek.com > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Dirk Bulinckx > Sent: Friday, August 08, 2003 9:21 AM > To: [EMAIL PROTECTED] > Subject: RE: [SA-list] Suggestion > > > Good idea, that's even easier... > > Dirk. > Most of Woodstone's staff is currently on holiday, however support > checks > mail a couple of times a day (over a slow link). This does mean that > we > are not able to do all "normal" support tasks. > We will be back, in full force, on August 10th 2003. > > > > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Behalf Of Paul Ockenden > Sent: Friday, August 08, 2003 12:15 PM > To: [EMAIL PROTECTED] > Subject: Re: [SA-list] Suggestion > > > > > I suppose that we will have to change it :-) > > Or just rename it to "Auto-save on exit". At least then it'll be obvious > how it works. > > P. > > > > To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] > With the following in the body of the message: > unsubscribe SAlive > > > To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] > With the following in the body of the message: > unsubscribe SAlive > > --- > avast! Antivirus: Outbound message clean. > Virus Database (VPS): 8/5/2003 > Tested on: 8/8/2003 9:33:58 AM > avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com > > > > To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] > With the following in the body of the message: > unsubscribe SAlive > > > To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] > With the following in the body of the message: > unsubscribe SAlive > To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive --- avast! Antivirus: Inbound message clean. Virus Database (VPS): 8/8/2003 Tested on: 8/8/2003 1:32:04 PM avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 8/8/2003 Tested on: 8/8/2003 3:05:51 PM avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive --- avast! Antivirus: Inbound message clean. Virus Database (VPS): 8/8/2003 Tested on: 8/8/2003 3:08:13 PM avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 8/8/2003 Tested on: 8/8/2003 3:20:50 PM avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive --- avast! Antivirus: Inbound message clean. Virus Database (VPS): 8/8/2003 Tested on: 8/8/2003 3:22:52 PM avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com --- avast! Antivirus: Outbound message clean. Virus Database (VPS): 8/8/2003 Tested on: 8/11/2003 2:16:17 AM avast! is copyright (c) 2000-2003 ALWIL Software. http://www.avast.com To unsubscribe from a list, send a mail message to [EMAIL PROTECTED] With the following in the body of the message: unsubscribe SAlive
