利用LogParser分析IIS日志 

-- 每分钟访问量统计
LogParser.exe -i:IISW3C "SELECT QUANTIZE(TO_LOCALTIME(TO_TIMESTAMP(date, time)), 60) AS Minute, COUNT(*) AS Total FROM *.log GROUP BY Minute ORDER BY Minute" -o:datagrid

-- 日访问量统计
LogParser.exe -i:IISW3C "SELECT COUNT(*) AS Total FROM *.log WHERE DATE='2021-12-23' AND s-ip='xxx.xxx.xxx.xxx' " -o:datagrid
LogParser.exe -i:IISW3C "SELECT QUANTIZE(TO_LOCALTIME(TO_TIMESTAMP(date, time)), 86400) AS Minute, COUNT(*) AS Total FROM *.log GROUP BY Minute ORDER BY Minute" -o:datagrid

-- 每秒访问量统计
LogParser.exe -i:IISW3C "SELECT QUANTIZE(TO_LOCALTIME(TO_TIMESTAMP(date, time)), 1) AS SECOND, COUNT(*) AS REQCOUNT FROM *.log WHERE date > '2021-11-30' GROUP BY SECOND" -o:datagrid

``
posted @ 2021-12-27 10:44  ChasingDreams  阅读(60)  评论(0)  编辑  收藏  举报