"C:\Programs\Log Parser 2.2\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 C:\inetpub\logs\LogFiles\W3SVC1\u_ex13*.log"
23 Posts
Re: Converting IIS Log Time to Local Time
Dec 14, 2013 06:03 PM|Docfxit|LINK
Where does the output of Log Parser go to?
"C:\Programs\Log Parser 2.2\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 C:\inetpub\logs\LogFiles\W3SVC1\u_ex13*.log"
Thank you,
Docfxit
IIS Input Format