View Complete Thread
  • Re: Converting IIS Log Time to Local Time

    May 11, 2007 11:08 AM|Anonymous|LINK

    Try this:

    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"

    It worked for me.

    IIS Input Format