引用:
http://www.rupeng.com/news/11/222.shtml
工具:Log Parser Studio
查询访问量最高的页面
SELECT TOP 10 cs-uri-stem,count(cs-uri-stem) FROM ‘[LOGFILEPATH]’
where date=’2016-07-01’
group by cs-uri-stem
order by count(cs-uri-stem) desc
SELECT * FROM ‘[LOGFILEPATH]’
where date=’2015-11-05’ and cs-uri-stem=’/Main/WhoLearning’
查询指定页面,哪些ip最长访问
SELECT c-ip,count(c-ip) FROM ‘[LOGFILEPATH]’
where date=’2016-07-01’ and cs-uri-stem=’/api/Values/GetFC’
group by c-ip
order by count(c-ip) desc