2005191500@IIS日志分析
IIS 站点对应标识
%SystemDrive%\windows\system32\inetsrv\config\applicationHost.config
IIS 默认日志文件的存放路径
%SystemDrive%\inetpub\logs\LogFiles
命令:日志导入数据库
"C:\Program Files (x86)\Log Parser 2.2\logparser.exe" "SELECT TO_LOCALTIME(TO_TIMESTAMP(ADD(TO_STRING(date, 'yyyy-MM-dd '), TO_STRING(time, 'HH:mm:ss')), 'yyyy-MM-dd HH:mm:ss')) AS RequestTime, * FROM 'D:\u_ex20031814_x.log' to IISLog" -i:IISW3C -o:SQL -oConnString:"Driver={SQL Server};server=192.168.1.123,51433;database=Test;Integrated Security=SSPI" -createtable:ON