首页 > 代码库 > IIS 日志分析

IIS 日志分析

查看哪个IP访问量大,访问了什么地址,大可以看到攻击者IP:

select c-ip,count(c-ip) AS allcount,cs-uri-stem,cs-uri-query,cs(User-Agent)from#IISW3C# WHERE to_string(date,yyyy-MM-dd) = 2011-11-15groupby c-ip,cs-uri-stem,cs-uri-query,cs(User-Agent)order by allcount desc

分析IIS某端口日志:

SELECT * FROM #IISW3C#WHERE s-port = 80 AND to_string(date,yyyy-MM-dd) > 2014-06-01

 

 

参考:

http://cancait.blog.163.com/blog/static/213357442011101613934464/