CSV Input Format Examples
Average Processor Usage per Minute
Parse a PerfMon CSV log file and calculate the average processor usage per minute:LogParser "SELECT QUANTIZE([(PDH-CSV 4.0) (Pacific Daylight Time)(420)], 60) AS Minute, AVG([\\GAB1\Processor(_Total)\% Processor Time]) AS AVGProcessor FROM PerfMon_000001.csv GROUP BY Minute" -i:CSV -iTsFormat:"MM/dd/yyyy hh:mm:ss.ll"