Thursday, April 28, 2011

XComplica SharePoint 2010 Usage File Analyzer

At my last DIWUG talk I mentioned that the Web Analytics functionality in SharePoint 2010 begins with the WssTracing service creating .usage files in the 14\LOGS folder. These files are in some nice binary format and it would sometimes be nice if we could open these up for debugging purposes.

So I cracked open reflector today and had a look at the code MS uses to import these files. A day later, and I created a little tool that reads these files and lets you have a look into them.

You can download the XComplica SharePoint 2010 Usage File Analyzer for free, and I am willing to share the (messy) source code if anyone wants. All at your own risk of course, this is just something I threw together in one day.

UPDATE: The code is now on Codeplex

It's quite self explanatory, grab a copy of the .usage file you are interested in, open it with the tool and you will see all the entries is a nice table. The fist column is clickable and shows the details of each row, since there are seven types of usage entries that the files contain. Simple but effective

Nice surprise in my mailbox

I was awarded the Microsoft Community Contributor Award yesterday for the time I have spent in the forums. Thanks MS and whoever else may be responsible. I like new flair for my blog. Not quite at 37 pieces but working on it. :)

Thursday, April 14, 2011

Speaking at DIWUG

I will be speaking at our local user group (DIWUG) on the 26th of April. I will be talking about the built in Web Analytics in SharePoint 2010. For more info see the agenda. Should be a fun talk, I'll do my best to make it entertaining.

If there is anything specific you want to see/hear, leave a comment or get me on twitter @jcapka