Is there a log analyzer that will parse IIS logs into a database that can be viewed?

Question

I am looking for a tool that will dump its findings into an external database, such as sql. It doesnt have to be SQL we just want the data in some form of a database so we can manipulate it.

score 6 · Accepted Answer · answered Jun 23 '11 at 20:58

6

Does it have to be a database? You can use MS' own LogParser to manipulate the hell out of the logs to begin with, and not have to use an intermediate SQL layer.

Actually, LogParser can output to SQL as well, so you could use it to do exactly what you want, as well.

answered Jun 23 '11 at 20:58

mfinni

36,144
4
53
86

LogParser does a very nice job of reading and outputing the logs. Personally I like to push the log data into a RDBMS for detailed analysis. – Jeff Jun 24 '11 at 14:32
1

Thanks a bunch for the info. It took a little playing around to get it right but I believe this will do exactly what I want. – Brooke Ingersoll Jul 15 '11 at 21:22

score 2 · Answer 2 · answered Jun 23 '11 at 21:02

2

You may consider a centralized syslog repository like Splunk that allows you to search logs from all your servers.

answered Jun 23 '11 at 21:02

Matt Beckman

1,502
18
33

score 0 · Answer 3 · answered Jun 24 '11 at 07:36

0

Yes, ManageEngine EventLog Analyzer can parse the IIS logs into MySQL or MS SQL database. The full feature trial version takes care of your requirement.

answered Jun 24 '11 at 07:36

Ragavan S

1

Is there a log analyzer that will parse IIS logs into a database that can be viewed?

3 Answers3