Queries
Get the Top20URIs.sql SQL query for use with the LogParser.exe command-line tool.
Some of these sample queries contain a FROM ex*.log statement. When using these queries, you must execute Log Parser from a directory containing IIS W3C log files, such as LocalDrive:\Windows\system32\LogFiles\W3SVC*#,* where # is the Web site ID.
Note: If you would like to execute Log Parser using a query that extracts data from ex*.log files (IIS log files), you can specify an absolute or relative path in the FROM statement. The path cannot contain spaces or quotation marks.