CodeRooster
asked on
Analyze/Parse an Apache Access Log
I'm trying to analyze an 8gb apache access log file. I've downloaded the file to my machine but it seems to big to manage directly in a text editor. Is there something I can use to parse the details of a log file? I need to look at certain date ranges and certain url redirects. In the end I would like to graph them. An excel would be great to sort and filter but I don't think it can handle a file of that size. Any thoughts?
Also, is there something out there to get this into a database where I can query it directly?
Also, is there something out there to get this into a database where I can query it directly?
if you apache is in windows, you can configure logparser and send the log data into the SQL server . from sql server you can get the table data directly from Excel. i can help you if your apache server is in windows. :-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
very good tools thank you.