Select Top 20
LogRow as [Line Number],
date as [Date],
time as [Time],
c-ip as [Client-IP],
s-ip as [Server-IP],
s-port as [ServerPort],
cs-method as [RequestVerb],
cs-uri-stem as [RequestURI],
sc-bytes as [BytesSent],
sc-status as [Status],
sc-substatus as [Sub-status],
sc-win32-status as [Win32Status],
time-taken as [TimeTaken]
From
C:\inetpub\logs\LogFiles\W3SVC6\u_ex141030.log
where [RequestURI] like ‘百%‘
Order by time-taken desc
---执行命令--LOGPARSER -i:IISW3C file:C:\iis2sql.sql -o:DataGrid -q:off
---gui工具logparserlizard
原文：http://www.cnblogs.com/Rannie/p/4070912.html