i have some apache logs and i want to be able to query the data in it.
so i wanted to know if its possible to convert this log data to a relational database so i later can query and analyze the data using sql statments.
thanks
views:
145answers:
1
+4
A:
Log Parser by Microsoft will let you query various types of data with SQL without needing to convert it.
Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows® operating system such as the Event Log, the Registry, the file system, and Active Directory®. You tell Log Parser what information you need and how you want it processed. The results of your query can be custom-formatted in text based output, or they can be persisted to more specialty targets like SQL, SYSLOG, or a chart.
RedFilter
2010-03-12 15:21:55
does it support apache logs?
Karim
2010-03-12 15:24:09
Yes, you can configure it to parse most types of logs.
RedFilter
2010-03-12 15:25:13
Updated with a newer link.
RedFilter
2010-03-12 15:27:00
I think you can also get it to write to a relational database as well - probably better from a performance point of view if you have a large number of logs.
Kragen
2010-03-12 15:35:53