IIS 日志分析

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-15'
groupby c-ip,cs-uri-stem,cs-uri-query,cs(User-Agent)
order by allcount desc

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