IIS Input Format Examples
Top 20 URL's for a Site
Create a chart containing the TOP 20 URL's in the "www.margiestravel.com" web site
(assumed to be logging in the IIS log format):
LogParser "SELECT TOP 20 Target, COUNT(*) AS Hits INTO MyChart.gif FROM <www.margiestravel.com> GROUP BY Target ORDER BY Hits DESC" -chartType:Column3D -groupSize:1024x768
Export Errors to SYSLOG
Send error entries in the IIS log to a SYSLOG server:
LogParser "SELECT TO_TIMESTAMP(Date, Time), CASE StatusCode WHEN 500 THEN 'emerg' ELSE 'err' END AS MySeverity, HostName AS MyHostname, Target INTO @myserver FROM <1> WHERE StatusCode >= 400" -o:SYSLOG -severity:$MySeverity -hostName:$MyHostname
Bytes by Extension Chart
Create a pie chart with the total number of bytes generated by each
extension:
LogParser "SELECT EXTRACT_EXTENSION(Target) AS Extension, MUL(PROPSUM(BytesReceived),100.0) AS Bytes INTO Pie.gif FROM <1> GROUP BY Extension ORDER BY Bytes DESC" -chartType:PieExploded -chartTitle:"Bytes per extension" -categories:off
© 2004 Microsoft Corporation. All rights reserved.