Thursday, March 3, 2011

Log parser to analyze IIS Logs

Hey You can use Log parser to analyze IIS logs..

But how do you find the local time

To find local time format for IIS logs
LogParser "SELECT TO_TIMESTAMP(date, time) AS utc-timestamp, TO_LOCALTIME(utc-timestamp) AS local-timestamp, c-ip, cs-username, EXTRACT_TOKEN(cs-uri-stem,-1,'/') AS filename INTO DATAGRID FROM \\WEBSERVER\admin$\system32\logfiles\w3svc1\ex07*.log"

No comments:

Post a Comment