網站大流量分析

引用：

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