Set up Log Parser Task from IIS to Database   

 

Set up the windows scheduler to execute this statement

LogParser "SELECT TO_TIMESTAMP(date,time) as timestamp, date, time, To_STRING(TO_TIMESTAMP(date,time),'hh:mm:ss') AS Hour, TO_Int(TO_String(date,'MM')) as Month, TO_Int(TO_String(date,'yyyy')) as year,c-ip, cs-username, s-sitename, s-computername, s-ip, s-port, cs-method, cs-uri-stem, cs-uri-query, sc-status, sc-substatus, sc-win32-status, sc-bytes, cs-bytes, time-taken, cs-version, cs-host, cs(User-Agent), cs(Cookie), cs(Referer) FROM C:\windows\system32\logfiles\W3SVC1041396893\*.log TO TestLog" -i:IISW3C -o:SQL -server:(local) -database:Logs -createtable:ON -iCheckPoint:myCheckPoint.lpc

Published  on  4/1/2009  by  xsolon
0  Comments  |  Trackback Url  | 0  Links to this post | Bookmark this post with:          
Tags: | Categories:
Technorati Tags:
 

Links to this post

Comments

Title:
Receieve Notification:
Website:
Email:
Comments:

CAPTCHA Image Validation