RE: How to Log to Both Database and File?

  • From: "Anthony Kariuki" <a.kariuki@xxxxxxxxxx>
  • To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx>
  • Date: Mon, 12 May 2003 08:55:04 +0300

Hello Anthony
 
ISA comes with some 3 SQL scripts which you use to create SQL tables. (do a 
quick search with *.sql in MS ISA installation folders). 
 
Using your ODBC manager, create a DSN to the database.
 
If you choose to log to a database, you are required to enter in the ODBC 
infomation (the DSN) and the particular table to log into. Otherwise you could 
use SQL Data transformation Services (DTS) to let SQL import the text data from 
the logs on a scheduled basis.
 
The DSN can also point to a MS Access databse - most peoples workhorse.
 
anthony

        -----Original Message----- 
        From: Anthony Dowling [mailto:antman147@xxxxxxxxxx] 
        Sent: Sun 11/05/2003 13:10 
        To: [ISAserver.org Discussion List] 
        Cc: 
        Subject: [isalist] How to Log to Both Database and File?
        
        

        http://www.ISAserver.org
        
        
        Hi,
        
        I was wondering if it is possible to setup ISA to log to both files and
        database?  The dialogs in the Log Setup only seem to allow one or the 
other,
        however someone may know of a way around this, or a util that will 
import
        the log files into a database (Which I could do manually)
        
        Any ideas on this would be much appreciated.
        
        Cheers
        
        Ant Dowling
        
        p.s. Apologies if this Message has come thru twice, as I received some
        reject message regarding list manager or something.
        
        
        ------------------------------------------------------
        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
        ------------------------------------------------------
        Exchange Server Resource Site: http://www.msexchange.org/
        Windows Security Resource Site: http://www.windowsecurity.com/
        Windows 2000/NT Fax Solutions: http://www.ntfaxfaq.com
        ------------------------------------------------------
        You are currently subscribed to this ISAserver.org Discussion List as: 
a.kariuki@xxxxxxxxxx
        To unsubscribe send a blank email to 
leave-isalist-1047923N@xxxxxxxxxxxxx
        

Other related posts: