Very useful tool Thanks Rooba
we have a need to show Most viewed Pages,Top visitors in SharePoint 2013 site. will this work for SharePoint 2013?
Sure. The tool just takes a look at IIS log settings and isn't dependent upon a specific version of SharePoint. Having said that, I've only tested it for sps 2007, 2010, and 2013.
Script is running successfully but the target folder is empty. IIS log files are enabled i can see them at c:\inetpub\logs
\logfiles Can you please help me to find what could be the issue. Thanks, karim
Results are written to the location where sfwr is located, not to the target folder. Please check that location.
Items in memory: 2407501 Items in memory in words: 2 Million, 4 x 100.000 and something... Finished importing file: D:\SFWR\W3SVC12
40483922\u_ex13 0611.log Importing file: D:\SFWR\W3SVC12 40483922\u_ex13 0612.log Failed to process line 2013-06-12 07:17:06 fe80::3883:3ced :9e90:4ac%11 POST /_vt i_bin/sitedata. asmx - 2010 DMZ01\VXQ-svc-F Crawl fe80::3883:3ced :9e90:4ac%11 Mozi lla/4.0+(compat ible;+MSIE+4.01 ;+Windows+NT;+M S+Search+6.0+Ro bot) 200 0 0 46: Exc eption of type 'System.OutOfMe moryException' was thrown. Failed to import W3C IIS log files
This is normal. I use the DLR to create in-memory objects, so I'm able to query them later to produce reports. But... there's a limit to the amount of objects that can be handled by .NET, so that's why you're getting this error. What I suggest you do is this: split the IIS log files in smaller batches using a tool such as GSplit. Then, analyze those. That's what I do, when needed. Make sure the batches are logical, e.g., if there's a lot of traffic, I create batches for every hour, 2 hours, 4 hours or as needed.
Just trying to use this application but it showing error message "To run this application, you first must install one of the following version of the .NET Framework: v4.0" Please suggest!!
This application uses parallel programming found in the .NET 4 framework. So, as the error messages said, you need to have it installed in order to run sfwr.
Can there be options to output in other formats (ie. CSV)?
Good suggestion, but for now I haven't built this in.
Hello there, Keep getting "Failed to import W3C IIS log files" when I enter the command "sfwr.exe 100 c:\logs\temp". Please help :) -Sid
Hi Sid, You are not providing LOG path of IIS folder or you can try puting all logs files in c:\logs\temp this path only.
That's the message I get when I run it. Any advice on this?
It may be so that it lacks essential info to be able to extract useful info. For example, I use bytes sent and bytes received a lot. If it's possible to send me some example log files you're having problems with, I could take a look at the reason why it fails.
Not everybody has the same IIS logging settings, that's why SFWR uses the DLR to support this. Nevertheless, there were certain reports that threw exceptions and caused processing to halt because they expect certain data to be present (mainly bytes sent and bytes received). v1.3 uses a little Aspect Oriented Programming (AOP) to make sure all report calculation errors are handled. If you care to check it out again, I assume it works now.
There may have been another reason: SFWR is not able to deal with changed log formats within a single log file. For example, you're logging IIS data in one way, and then decide to remove some fields and add a couple of other ones. You can test this by running sfwr on a specific log file that you know didn't change it's format.
after i run the exe,nothing happen. may i know how to use it?
Just run it like this from the command prompt: sfwr.exe 100 c:\temp\logs If that doesn't work, there might be something special with your log files, and I'd be interested to take a closer look at them.