Log file reader

I don't want stats, I want to run queries on my logs!

[nmattheij]

I'd like to have a program that allows me to import one or more log files into a database so I can run queries on the different fields.

At the moment I have to browse though them manually, which isn't very comfortable because:
- I can't filter out certain hits on IP, or filetype
- I can't decide what data to show, often have to scroll sideways to get the data I want.

Anyone have an idea?

[Receptional]

Well, a log file is just a text file, Presumably comma delimited. So you should be able to import it into almost any database.

You could probably import into Excel. I hear 2007 is not restricted to 64000 lines any more. But I guess a database makes more sense.

[JesperFJ]

Hi

Yes, I got an idea.
With LogParser 2.2, you can query directly on e.g. IIS logfiles without importing into a database. More or less standard SQL syntax.

[nmattheij]

LogParser 2.2 does what I need, and pretty quick too.

Thanks