Tuesday, September 22, 2009

Using LogParser to get Download Details from IIS

LogParser is the wonderful application which parses all the information in IIS.

I came across a situation, where i needed to get total number of downloads of video files from the website.

Logparser saved my time, by querying the IIS logs for the downloads.



logparser.exe "select top 50 count(*) as downloads, cs-uri-stem from ex*.log where cs-uri-stem like '%.wmv%' group by cs-uri-stem order by downloads DESC"


The above command gives top 50 downloads of movies of type ".wmv"

Happy Coding...

Labels: , , , , , ,