RE: AW: logging to a database - anyone do it?
- From: "Joseph" <cismic@xxxxxxx>
- To: "'[ISAserver.org Discussion List]'" <isalist@xxxxxxxxxxxxx>
- Date: Wed, 23 Jan 2002 17:57:30 -0800
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')
Other related posts:
