dumping Windows Event logs mysql
I am looking for all kinds of input and opinions, please feel free to comment. 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? 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
please keep in mind, I am a Sysadmin with Zero budget, so I am looking for freeware solutions.
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?

