CSV Input Format Examples

Log Parser

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"


© 2004 Microsoft Corporation. All rights reserved.