Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page Properties
hiddentrue
idKB


ThemeLogging
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.

Table of Contents

Anchor
logparser
logparser
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

Anchor
studio
studio
Log Parser Studio

Microsoft'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
titleFile paths


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

  1. Download Log Parser or Log Parser Studio
  2. Download the attached zip file "auditing.zip" and ensure it's unblocked before extracting
  3. Extract it to somewhere like the Astun Tools folder (normally on the D: drive)

...