How to use IIS Logs with LOGPARSER

Exemplo de pesquisa do logparser para logs de iis

LogParser -i:IISW3C "SELECT * FROM \\servername\LogsConsolidation\Repository\W3C3\*.log WHERE cs-uri-stem  '/imagesSite/cover.jpg' " -o:CSV > C:\HitsCovers.csv
Resultado:

 

 

Outro exemplo agora com datas:

 

LogParser -i:IISW3C "SELECT * FROM \\ServerName\LogsConsolidation\Repository\W3C3\*.log WHERE cs-uri-stem = '/imagesServerName/imgCovers.jpg' AND (DATE >= '2012-11-16' AND DATE <= '2012-11-23')  " -o:CSV > C:\HitsCovers_Nov16_23.csv