Dumping the Windows Event Log to MySQL

Tech-Archive recommends: Speed Up your PC by fixing your registry

I am looking for all kinds of input and opinions, please feel free to comment.
please keep in mind, I am a Sysadmin with Zero budget, so I am looking for
freeware solutions.

Right now, I have a crummy method of viewing the event logs, and I would
like to make this easier. I have 60+ windows servers that may grow to 200+
and possibly include linux/unix in the future.

The goal here is to be able to view my event logs through a nice searchable
web interface. So I can search by user name to find log on locations and
times, errors on the servers, and anything else that I may be able to find in
the logs.

So, my current idea is to dump the logs to a central point, and write a web
page to search the logs. I have a solution in effect now that will allow me
to dump the logs to a massive flat text file, and am considering writing a
Perl or php script to search the flat file. But this file may be up to 80
megs, every day. So i am considering dumping the event logs directly into a
MySQL database, but i do not know of any tools to do this.

So my questions are like this;

1) Is there a freeware tool to dump event logs to a MySQL database?
2) What other tools are there for dumping the event logs?
3) Is there perhaps a freeware solution that has already done all the work
that I can't seem to find?

I would be very interested in all input here.

P.S. Lets say for the sake of argument that i was able to by a Solution, is
anyone very happy with there event log products? (for future reference)

.

Relevant Pages

  • Re: Dumping the Windows Event Log to MySQL
    ... > freeware solutions. ... > The goal here is to be able to view my event logs through a nice searchable ... > So, my current idea is to dump the logs to a central point, and write a web ... > 1) Is there a freeware tool to dump event logs to a MySQL database? ...
    (microsoft.public.windows.server.active_directory)
  • Re: Dumping the Windows Event Log to MySQL
    ... > freeware solutions. ... > Right now, I have a crummy method of viewing the event logs, and I would ... > MySQL database, but i do not know of any tools to do this. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Dumping the Windows Event Log to MySQL
    ... Not sure if this will work with mySql but if you can find a windows mysql ... includes writing event logs to a database. ... > freeware solutions. ...
    (microsoft.public.windows.server.active_directory)
  • RE: Event log managment
    ... > We use dumpel to dump them to text ... > I then use Excel to check my event logs. ... a SQL db as well as to comma-delim. ... Check out Yahoo! ...
    (Focus-Microsoft)
  • Re: Dumping the Windows Event Log to MySQL
    ... >> Right now, I have a crummy method of viewing the event logs, and I ... >> So, my current idea is to dump the logs to a central point, and write ... >> 1) Is there a freeware tool to dump event logs to a MySQL database? ... Minasi has a great write-up about MSDE in his current news letter at ...
    (microsoft.public.windows.server.active_directory)