Welcome to Matts Admin tips. This blog is full of little fixes, tutorials and work-arounds to those anoying problems that a Systems Administrator might face. If you find something that you have found useful please leave me a comment - I appreciate knowing that I've helped! Also, feel free to leave a comment if my tips or ideas don't work in your environment... I monitor them closely and would be happy to help! Matt

IIS LogParser – Hits in last 7 Days

Posted May 18th, 2009 by Matt Shadbolt

Here’s a LogParser query I’ve written that will output the top hits for your website within the last 7 days. All you need to do is change the path of the log file location: SELECT  COUNT(*) AS Hits, cs-uri-stem AS Page FROM D:\LogFilePat*.* WHERE TO_DATE(Date) >= TO_DATE(SUB(SYSTEM_TIMESTAMP(), TO_TIMESTAMP(’01-07′, ‘MM-dd’))) GROUP BY cs-uri-stem ORDER BY Hits [...]

Tags: ,

Filed under:Uncategorized