Log ParserでPV集計

On By cyberarchitect

　

おなじみのLog Parser。わたしもアクセス解析に利用させてもらっている。

1分単位のPVを集計

logparser "Select QUANTIZE(time, 60) As Minutes, Count(*) As PV INTO ex070302.csv From ex070302.log Where (cs-uri-stem not like '%.gif' and cs-uri-stem not like '%.js' and cs-uri-stem not like '%.css' and cs-uri-stem not like '%.jpg' and cs-uri-stem not like '%.jpeg') Group by Minutes"

なかなかすぐれもの。自動化したいなあ。