There are instructions at isaserver.org and in the ISA help for setting up ODBC logging for ISA. You don't have to create all the tables by hand. Jim Harrison MCP(NT4, W2K), A+, Network+, PCG http://isaserver.org/authors/harrison/ Read the books! ----- Original Message ----- From: "Joseph" <cismic@xxxxxxx> To: "[ISAserver.org Discussion List]" <isalist@xxxxxxxxxxxxx> Sent: Wednesday, January 23, 2002 17:57 Subject: [isalist] RE: AW: logging to a database - anyone do it? http://www.ISAserver.org Logging is a fun issue for me! You have to create the columns and tables. For ODBC logging there is a set format as required by IIS. If you import Your own logs there still are a set format for the fields that IIS generates. Once you have your flat file created then you can parse via T-SQL the information that you want to analyze into summary tables, OLAP tables And do all the data mining your heart desires. -----Original Message----- From: Anthony Michaud [mailto:anthonym@xxxxxxxxxxxxxx] Sent: Wednesday, January 23, 2002 4:55 PM To: [ISAserver.org Discussion List] Subject: [isalist] RE: AW: logging to a database - anyone do it? http://www.ISAserver.org With regards to setting up logging to a database, what is the easist method for doing this? Do you simply have to setup a database, and the logging service creates tables / columns etc, or do you have to create the columns/tables yourself? I've been looking at doing something like this for a while, but haven't been able to find the time to sit down and look at it. If I get the database going, the ASP should be reasonably easy to code, and I'd be happy to share :) -- Anthony Michaud Network Administrator Act! Certified Consultant eLogix Corporation Pty Ltd You've got an anti-anti-antimissile missile? Well, we've got an anti-anti-anti-antimissile missile!" - Get Smart! > -----Original Message----- > From: Cosman Peter [mailto:peter.cosman@xxxxxxxxxxx] > Sent: Wednesday, 23 January 2002 19:13 > To: [ISAserver.org Discussion List] > Subject: [isalist] RE: AW: logging to a database - anyone do it? > > > http://www.ISAserver.org > > > Jonathan, > > We have logging to a database enabled since september 2001. > This works fine > but the problem is that a lot of reporting software doesn't > work with ODBC > logging (only textfiles). > Our database is now about 50 GB. > > BTSpider from burstek should be possible but we haven't got > this software > working (also due to a lack of support from burstek). > > _____________________________________ > > Cosman Peter, System Administrator > A.Z. St.-Jan Brugge > Ruddershove 10 > 8000 Brugge > > E-mail: peter.cosman@xxxxxxxxxxx > > _____________________________________ > > > > -----Oorspronkelijk bericht----- > Van: Jonathan Hjertström > [mailto:jonathan.hjertstrom@xxxxxxxxxxxxxxxxx] > Verzonden: woensdag 23 januari 2002 09:04 > Aan: [ISAserver.org Discussion List] > Onderwerp: [isalist] RE: AW: logging to a database - anyone do it? > > > http://www.ISAserver.org > > > > This is a multi-part message in MIME format. > > ------------------------------------------------------ > You are currently subscribed to this ISAserver.org Discussion > List as: anthonym@xxxxxxxxxxxxxx > To unsubscribe send a blank email to > $subst('Email.Unsub') > ------------------------------------------------------ You are currently subscribed to this ISAserver.org Discussion List as: cismic@xxxxxxx To unsubscribe send a blank email to $subst('Email.Unsub') ------------------------------------------------------ You are currently subscribed to this ISAserver.org Discussion List as: jim@xxxxxxxxxxxx To unsubscribe send a blank email to $subst('Email.Unsub')