<dancing a jig> Woohoo!!!! Shebang!!!! Yeah Baby!!! </dancing a jig> Thanks Joseph. Just got back from 3 weeks leave and your e-mail was number 1322 in the list and you have just made my day!!!! One small thing though.. Jim's website only has the following Web <http://isatools.org/webimport.zip> Import Tool 03/05/02 1.0 Joseph Kravis <mailto:cismic@xxxxxxx?subject=Web%20Log%20SQL%20Import%20Tools> SQL and VBScript to combine ISA and IIS web logs into a SQL DB Seems a little old to me.? It also only contains 3 scripts. Am I missing something? I also cannot yet access your website. Is it up yet? Cheers William R. -----Original Message----- From: cismic [mailto:cismic@xxxxxxx] Sent: 17 December 2003 23:07 PM To: [ISAserver.org Discussion List] Subject: [isalist] Log Files Sensitivity: Confidential http://www.ISAserver.org Hi All, Log files are not only important to identifying visits to a site but to help identify weather or not you have malicious activity going on. I'm not a firm believer in writing directly to an ODBC db source from within ISA and have created scripts to assist me with importing scripts into my db. I've been working on these tasks for 2 years now. Learning a lot about ISA in the process. Script 1: Moves the log files to another location daily that's if you haven't setup a location different then the defaults and set them up to use appropriate security access. Script 2: Imports the Web Proxy Logs Script 3: Imports the Firewall Logs Script 4: Imports the packet filter logs Script 5: Process the event logs,( System, Security and Application) then imports into the Db Script 6: Imports Exchange server logs Script 7: Imports FTP Logs Script 8: Imports RRAS information Ok, you say, where are these wonderful scripts?? Well, I will send them To Jim Harrison for posting on his site on Christmas Eve at least that's what William would like for Christmas. And they will be available on my site http://www.stat-sphere.com after I get the rewrite and new graphics done before the end of the year. I have my hands full! Scripts by the way is just half the battle. I have SQL functions that parse the data into daily, weekly, monthly and yearly process. Hits by browser, country, user agents etc. If any of your are running IIS 5.0 or IIS 6.0, I plan on releasing a version of http://www.stat-sphere.com code where you can plug in the various modules that I've been working on the past 2 years. Thank you, Joseph ------------------------------------------------------ List Archives: http://www.webelists.com/cgi/lyris.pl?enter=isalist ISA Server Newsletter: http://www.isaserver.org/pages/newsletter.asp ISA Server FAQ: http://www.isaserver.org/pages/larticle.asp?type=FAQ ------------------------------------------------------ Other Internet Software Marketing Sites: Leading Network Software Directory: http://www.serverfiles.com No.1 Exchange Server Resource Site: http://www.msexchange.org Windows Security Resource Site: http://www.windowsecurity.com/ Network Security Library: http://www.secinf.net/ Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com ------------------------------------------------------ You are currently subscribed to this ISAserver.org Discussion List as: robertson.william@xxxxxxxxxxxxxx To unsubscribe send a blank email to $subst('Email.Unsub') --------------------------------------------------------------------- Everything in this e-mail and attachments relating to the official business of Columbus Stainless is proprietary to the company. It is confidential, legally privileged and protected by law. Columbus Stainless does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Columbus Stainless. The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way. Whilst all reasonable steps are taken to ensure the accuracy and integrity of information and data transmitted electronically and to preserve the confidentiality thereof, no liability or responsibility whatsoever is accepted if information or data is,for whatever reason, corrupted or does not reach its intended destination. ---------------------------------------------------------------------