2005191500@IIS日志分析

Author Avatar
ClueeZhuo 5月 19, 2020

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