IIS LogParser – Hits in last 7 Days

Here’s an IIS 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… Read more

IIS ODBC Logging Event ID 1016 (error data 80070057)

“The World Wide Web Publishing Service (WWW Service) did not configure logging for site X. The data field contains the error number.” This warning will show up in your System event logs and you custom IIS logging to a SQL database won’t work. Obviously the message is fairly cryptic, however in a facepalm sort of… Read more