iis 日志分析

使用工具LogParser  和Log Parser Studi

sql 语句

SELECT * from  '[LOGFILEPATH]' where  c-ip ='x.x.x.x' and cs-uri-stem='/xxxx.aspx'

SELECT cs-uri-stem,c-ip,count(1)  FROM '[LOGFILEPATH]' 
where  to_time(time)>'17:00:00'
 and to_time(time) <'18:00:00' 
 group by cs-uri-stem,c-ip order by count(1)  desc