Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a particular requirement to analyse the IIS web logs and view which users (by username) have accessed a particular subset of pages.

Can anyone recommend a good analysis tool to get this information from the logs.

The ones I have looked at SmarterLogs and WebLog Expert seem to either list numbers of user (not who) have accessed a page. And don't offer selecting which pages you are interested in...


Apologies for re-opening this question. It seems the IIS logs didnt have the information I was after. I was looking for each user request of documents within a SharePoint 2003 document library. It seems that that this logging has to be enabled in SharePoint

Has anyone tried to do this before in SP2003? And can I still use Log Parser?


locked by HopelessN00b Jan 25 '15 at 7:30

This question exists because it has historical significance, but it is not considered a good, on-topic question for this site, so please do not use it as evidence that you can ask similar questions here. This question and its answers are frozen and cannot be changed. More info: help center.

closed as off-topic by HopelessN00b Jan 25 '15 at 7:30

This question appears to be off-topic. The users who voted to close gave this specific reason:

If this question can be reworded to fit the rules in the help center, please edit the question.

Thanks guys was hoping more for a analytics tool that would do this and produce reports that I can show to the business. – nav Jul 18 '11 at 12:20
Why is your business incapable of reading plain text? For that matter, if they need "pretty", wrap the results in some HTML and print that out. – womble Jul 18 '11 at 12:23
Log parser can be used to generate graphs and charts using the data in the target log files, its a matter of formatting the query properly. There's also this tool that may generate picture-based output for you: – John Ferringer Jul 19 '11 at 12:07
@womble I should have worded the comment better, what I meant is to set up automated reports against the log files, rather than it being pretty but pretty would be good too! – nav Jul 21 '11 at 8:24
You're allowed to automatically run Ruby scripts, you know. – womble Jul 21 '11 at 8:46
up vote 6 down vote accepted

My favorite tool for this is Log Parser (recommended initially by Peter), it has a bit of a learning curve but its very versatile. Microsoft PFE has a pretty good blog post on common queries to use to get data out of IIS logs with Log Parser, some of those queries may provide you with a quick leg up on what you're wanting to extract:

There's also a GUI tool for Log Parser called "Log Parser Lizard" which can simply it for you somewhat:

I also found a free tool that someone posted at that may be worth a look, but I haven't tried it myself yet:


+1 for Log Parser. The tool is great, especially if you have SQL language experience. – Jeff Jul 19 '11 at 22:02

If you are familiar with writing SQL queries, one option would be to import them into a database such as SQL Server. This is documented across the web, Microsoft doing it at

An alternative might to be to use a tool such as Microsoft's Log Parser, but it uses a similar query language.

thanks great suggestions – nav Jul 21 '11 at 8:14

If you can describe the "subset of pages" as a regex, the following ruby should do the trick (feed the log into standard input):

users = []
$stdin.each_line { |l| next unless l =~ %r{interestingpagesregex}; u = l.split(/\s+/)[1]; users << u unless users.include? u }
puts users

Not the answer you're looking for? Browse other questions tagged or ask your own question.