Link to home
Start Free TrialLog in
Avatar of CodeRooster
CodeRoosterFlag for United States of America

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?
Avatar of axi
axi
Flag of Nepal image

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
Avatar of rbdnz
rbdnz
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CodeRooster

ASKER

very good tools thank you.