RE: test

  • From: "Darren" <darren.lacy@xxxxxxxxxxxxxxxxxx>
  • To: isalist@xxxxxxxxxxxxx
  • Date: Wed, 26 Sep 2001 07:38:36 -0600

Joseph:

I had exactly the same needs as you for analyzing ISA logs.  Here was my
approach.

Configure ISA to log directly to SQL Server through an ODBC connection,
(This works with IIS as well).  Be careful to set it up correctly since
the ISA services will not start if they can't write to their log.  The
install CD even contains the SQL scripts necessary to automatically
generate the tables and default indexes ISA needs.  You can run these in
Enterprise Manager or Query Analyzer.  Then you can use what ever
reporting tools you have at your disposal to pull the data from the
database.

If you need, or would like any other details about logging directly to SQL
Server, feel free to send me a note at darren.lacy@xxxxxxxxxxxxxxxxxxx

Hope this helps,

Darren Lacy
Decision Source, Inc.


Other related posts: