IIS log analyzing tool based on LogAnalyzer

Indihiang Project is a IIS log analyzing tool based on LogAnalyzer. This tool analyzes IIS Web server in comprehensive graphs and reports. The project is located at codeplex: http://indihiang.codeplex.com/ and makes a very good impression. I could easly analyze IIS Logfiles which have a size of 1.2 GB and a bit more.

Project Features:

• Web Log Viewer
• Web Log Analyzer
• Web Log Consolidation
• Web Log Real-time Monitoring
• Support for IIS6 and IIS7
• Trend Data Analysis
• Trend Data Reporting

LogParser SQL Statemts for IIS Log files

I uploaded some LogParser SQL Statements for IIS Log files.

• http://www.ronischuetz.com/code/AverageResponseTimePerHour.html
• http://www.ronischuetz.com/code/Hit_Frequency.html
• http://www.ronischuetz.com/code/NetworkAnalysis.html
• http://www.ronischuetz.com/code/RequestsPerHour.html
• http://www.ronischuetz.com/code/RequestsPerMin.html
• http://www.ronischuetz.com/code/RequestsPerMin_WebSites.html
• http://www.ronischuetz.com/code/ResponseTime.html
• http://www.ronischuetz.com/code/Top50LongestRequest.html
• http://www.ronischuetz.com/code/unique_clients.html
• http://www.ronischuetz.com/code/uniqueClientsPerHour1.html
• http://www.ronischuetz.com/code/uniqueClientsPerHour2.html

with a simple batch job you able to execute all queries at once:

• http://www.ronischuetz.com/code/runAllQuery.html

Download: http://www.ronischuetz.com/code/LogParserSqlScripts.zip