Microsoft Log Parser Toolkit
By Gabriele Giuseppini, Mark Burnett
Checking the fields parsed by LogParser from the CSV file.
logparser.exe file: -i:CSV Test_000001.csv -iTsFormat: “MM/dd/yyyy hh:mm:ss.ll”
Example, of a query to calculate the average, maximum and minimum number of processes in each minute:
SELECT TO_STRING(Minute, ‘hh:mm’) As MinuteStr,
AVG(\\GAB1\System\Processes) As AvgProc,
MAX(\\GAB1\System\Processes) As MaxProc,
MIN(\\GAB1\System\Processes) As MinProc
USING QUANTIZE([(PDH-CSV 4.0) (Pacific Daylight Time) (420)], 60) As Minute
FROM Test_00000.csv
GROUP BY Minute
logparser.exe file:Ch01PerfMonAverages.sql -i:CSV -iTsFormat:”MM/dd/yyyy hh:mm:ss.ll”
