#98583 - 2003-02-19 02:58 PM
Re: open, readline, close
|
Crazy Eddie
Starting to like KiXtart
Registered: 2002-11-20
Posts: 105
Loc: Sacramento, CA USA
|
You might also want to review this MS utility, as an alternative.
I've had great results using it to dump Event Logs to a CSV, and then upload them into SQL. (Note: The CSV step is optional for our environment. You could go directly.)
This is suprisingly good, considering the source.
Microsoft Log Parser 2.0
quote: Log Parser supports the following input formats: IISW3C: Internet Information Services (IIS) W3C Extended format. IIS: IIS-formatted and IIS-generated log files. IISMSID: Generated when the MSIDFILT filter or the CLOGFILT filter is installed. ODBC: IIS Open Database Connectivity (ODBC) format that reads data directly from the SQL table populated by IIS when the Web server is configured to log to an ODBC target. NCSA: National Center for Supercomputing Applications (NCSA) format. BIN: Binary file format that is generated by IIS 6.0. Contains the requests received by the virtual Web sites on the same server running IIS 6.0. URLSCAN: Generated by the URLScan filter if it is installed on IIS. HTTPERR: IIS 6.0 HTTP error log files format. W3C: W3C log file format, such as for personal firewall, Windows Media Services, and Exchange tracking logs. EVT: Event messaging format from the Windows Event log, including system, application, security, and custom event logs, as well as from event log backup files. FS: File information from the specified path, such as file size, creation time, and file attributes. It is similar to an advanced dir command. CSV: Generic comma-separated value format. TEXTWORD: Generic text format. TEXTLINE: Generic text format. Log Parser supports the following output formats: W3C: Sends results to a W3C text file that contains headers and values that are separated by spaces. IIS: Sends results to a text file with values separated by commas and spaces but no headers. SQL: Sends results to a SQL table using the ODBC Bulk Add command. CSV: Sends results to a text file. Following an optional header, values are separated by commas and optional spaces. XML: Sends results to an XML-formatted text file. The XML file is structured as a sequence of ROW elements, each containing a sequence of FIELD elements. TPL: Sends results to a text file formatted according to a user-specified template. NAT: Used for viewing native results on a screen.
(It is COM-able too.)
-Crazy Eddie
_________________________
{Insert your favorite Witty Tag Line here}
|
|
Top
|
|
|
|
open, readline, close
|
pvds
|
2003-02-20 12:03 AM
|
Re: open, readline, close
|
Lonkero
|
2003-02-20 12:11 AM
|
Re: open, readline, close
|
pvds
|
2003-02-20 12:59 AM
|
Re: open, readline, close
|
MightyR1
|
2003-02-19 01:14 PM
|
Re: open, readline, close
|
pvds
|
2003-02-19 01:23 PM
|
Re: open, readline, close
|
Richard H.
|
2003-02-19 01:32 PM
|
Re: open, readline, close
|
MightyR1
|
2003-02-19 01:38 PM
|
Re: open, readline, close
|
Howard Bullock
|
2003-02-19 02:00 PM
|
Re: open, readline, close
|
Jochen
|
2003-02-19 02:10 PM
|
Re: open, readline, close
|
Howard Bullock
|
2003-02-19 02:25 PM
|
Re: open, readline, close
|
Richard H.
|
2003-02-19 02:44 PM
|
Re: open, readline, close
|
Crazy Eddie
|
2003-02-19 02:58 PM
|
Re: open, readline, close
|
pvds
|
2003-02-19 03:17 PM
|
Re: open, readline, close
|
pvds
|
2003-02-19 08:01 PM
|
Re: open, readline, close
|
Lonkero
|
2003-02-19 08:04 PM
|
Re: open, readline, close
|
Sealeopard
|
2003-02-20 06:23 PM
|
Re: open, readline, close
|
Lonkero
|
2003-02-20 07:54 PM
|
|
Moderator: Arend_, Allen, Jochen, Radimus, Glenn Barnas, ShaneEP, Ruud van Velsen, Mart
|
0 registered
and 611 anonymous users online.
|
|
|