SecurityFocus had a great article approx 2 years ago about using LogParser as a forensic tool, their article demonstrates log file forensics of IIS logs using SQL queries with Microsoft’s LogParser tool.
LogParser is an awesome tool that can be great in facilitating log files in general.
Read the full articles at SecurityFocus: Forensic Log Parsing with Microsoft’s LogParser.