Page Properties |
---|
|
Theme | Logging |
---|
Type | Troubleshooting |
---|
Available from | |
---|
|
With iShare it can be useful to extract information from the IIS logs. This page details how to generate iShare Maps or iShare GIS reports from these IIS log files. You may also wish to view the page Analyse Logs using MS Log Parser for other examples.
Log Parser Log Parser is Microsoft's utility for treating log files, or directories of log files, like database tables, with a SQL-like syntax for constructing queries. MS Log Parser may be installed using the Astun 3rd Party installer or downloaded from the Microsoft web site:
http://technet.microsoft.com/en-gb/scriptcenter/dd919274.aspx
Log Parser StudioMicrosoft's graphical front-end for Log Parser. Select the preparedlogs
folder as the source log file path and ensure that the Log Type is set to W3CLOG
(not IISW3CLOG
which doesn't not allow custom fields such as those in the prepared logs folder). This tool is good for ad-hoc queries and testing changes to script SQL.
...
Info |
---|
|
Original log files | C:\Inetpub\Logs\Logfiles\W3SVC1* C:\Inetpub\Logs\Logfiles\W3SVC3* |
---|
Preprocessor script | D:\Astun\Stats\preprocessor.py |
---|
Preprocessor config | D:\Astun\Stats\preprocessor.cfg |
---|
Preprocessed log files | D:\Astun\Stats\PreparedLogs |
---|
Log Parser scripts | D:\Astun\Stats\Scripts\*.bat |
---|
Output files | D:\Astun\Stats\Output\*.csv |
---|
Log Parser | C:\Program Files (x86)\Log Parser 2.2\ |
---|
Log Parser Studio | C:\Program Files (x86)\Log Parser Studio\ |
---|
*These may vary depending on the sites set up in your installation |
Getting Started
- Download Log Parser or Log Parser Studio
- Download the attached zip file "auditing.zip" and ensure it's unblocked before extracting
- Extract it to somewhere like the Astun Tools folder (normally on the D: drive)
...