Welcome to MSDN Blogs Sign in | Join | Help

SharePoint Reporting Solution

I've been clamoring for a SharePoint Reporting solution.  Sure the SharePoint Usage reports are cute for the site administrator such as the search reports, and viewing the audit logs on a site.  If you aren't even seeing site usage data this troubleshooting page might be helpful. Note there is the WSS usage processing AND the MOSS shared service for Usage processing that both need to be enabled...  but what about farm reports?

Quest software - Capacity Manager for SharePoint (very interesting reports on Storage with a focus on SQL).  There is a free trial.  There are some interesting capacity reports, including growth and trending reports on the content databases with the capacity planner.

From their site: "Capacity Manager makes it easy for database administrators to manage SharePoint. The eye-catching reports provide graphs and charts on: 

Here's a good verbose blog post on different ways to pull usage data from SharePoint.  It's a bit dated, but there is some good mention of getting at it via FPRPC, SharePoint Designer, the OM, and the web UI.

I've got a call open with WebTrends to tell me "how to configure" WebTrends to work with WSS/MOSS.  They tell me they have support for SharePoint, but it just needs to be configured.  It's possible with nearly all web reporting usage products to give you the classic usage stuff (users, browsers, OSs, transfer, session lengths, etc..), but when you get into pages and paths through the site you'll find it's not what you need.  This is where I'm hoping to see partners step up.

Published Friday, September 28, 2007 11:52 PM by joelo
Filed under:

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

Sunday, September 30, 2007 1:02 PM by Bob Fox

# re: SharePoint Reporting Solution

Good info Joel.... you should also add the capability to view your usage reports inside of SPD as well.

On another topic somewhat related is the viewing of your SharePoint Logs when troubleshooting.  I tested and did a small review on IdevFactory's SWAT tool recently and found there log reader very usefull where you can really filter out information to make searching for issues painless.  You can read the review here http://bobfox.net/spblog/Lists/Posts/Post.aspx?ID=73

Im planning on doing a quick screencast to illustrate this.  On speaking with the developers this tool was a second thought addition to the tool.  Cool stuff.

Sunday, September 30, 2007 1:03 PM by Bob Fox

# re: SharePoint Reporting Solution

Whoops.. you did mention SPD  :)  Pays to read the entire article.

Sunday, September 30, 2007 7:46 PM by sean kelley

# re: SharePoint Reporting Solution

i definitely agree this is an area in which sharepoint is lacking. i'm currently working on a project to provide farm wide stats for our mms customers. joel i'd be glad to give you a demo when we're complete

Sunday, September 30, 2007 8:27 PM by Links (9/30/2007) « Steve Pietrek’s SharePoint Stuff

# Links (9/30/2007) « Steve Pietrek’s SharePoint Stuff

Monday, October 01, 2007 6:35 AM by saqibsabir

# re: SharePoint Reporting Solution

Hi Joel,

Did you get an update from Web Trends?  I am currently faced wih the same dilemma here at Centrica with a slight difference.

We are using Web Trends 8 here.

We are at SPS2003 and looking to migrate to MOSS - although the same problem still faces us.  Would be great to know if they have come back to you with a resolution.

Thank you.

Rgds,

Saqib

Monday, October 01, 2007 11:25 AM by Sahil Malik

# re: SharePoint Reporting Solution

Okay Quest Capacity Manager, while useful, isn't exactly a usage reporting solution for sharepoint.

I'd be interested in hearing what webtrends has to say.

Monday, October 01, 2007 10:28 PM by joelo

# re: SharePoint Reporting Solution

I've got some great feedback on this post.  I will post the results I get from Web Trends.  I also look forward to results from Sean and in a thread with other internal folk working with reporting solutions in relation to Web Trends.

Tuesday, October 02, 2007 2:00 AM by EROL

# re: SharePoint Reporting Solution

Tuesday, October 02, 2007 2:36 PM by BAG

# re: SharePoint Reporting Solution

What about host header-named site collections? Unless I've made a configuration oversight in my farm, traffic to these sites doesn't seem to show up in IIS logs. WebTrends would need to process WSS logs as well to capture usage info for these sites.

Tuesday, October 02, 2007 8:05 PM by BAG

# re: SharePoint Reporting Solution

Correction to my earlier comment about how to track usage reporting for host header site collections - the IIS log entries for these sites appear to be showing up in the SSP web app's logs. Unexpected, but that works!

Wednesday, October 03, 2007 11:55 AM by Sam Wilson

# re: SharePoint Reporting Solution

Hi Joel - we worked with MCS when we deployed SPS 2003 to create a utility that converted the SharePoint log files into W3C compliant files that WebTrends could parse. Likely created some of the DNA that turned into the MS log parser. While not elegant, this got us some mileage but analytics in SharePoint (all known current and future versions!) still needs attention. Ideally either there should be a way for high end analytics packages (Omniture, Visual Sciences etc ...) to tap into all of the events captured in the proprietary SharePoint logs but at a minimum people can always embed tracking beacons on pages for basic measurements.

Wednesday, October 03, 2007 4:50 PM by Sharepoint Use Cases

# SharePoint Usage Reports

One of my customers recently deployed intranet site on MOSS 2007. After a while we wanted to analyze

Friday, October 05, 2007 2:43 PM by joelo

# re: SharePoint Reporting Solution

Any one internal to Microsoft should look at http://msblogs/corybu/default.aspx  Cory is working on putting up his tool that provides usage data for SharePoint.  I'll be sure to promote it here when it is available.

Also, I am gathering data from the internal MSW team on their experience with WebTrends.

Friday, October 12, 2007 8:09 PM by joelo

# re: SharePoint Reporting Solution

Sam, I do think you captured it well.  Bots aka little .js scripts to capture usage on pages for tools like Omniture and WebTrends are good solutions today.  I hope to get people talking about what they've done and what needs they are getting addressed.

Thursday, October 25, 2007 2:18 PM by Mark Kruger

# re: SharePoint Reporting Solution

Joel,

Please keep us posted on any feedback with WebTrends.  You're right in that the Usage Reports were cute but I found them to be limited and inconsistent. :(  Dont really want to go the logparser route because that involves working with Operations folks. ;)

Saturday, October 27, 2007 7:29 AM by Ronen Meyuhas

# re: SharePoint Reporting Solution

CardioLog 2007 is a web analytics solution designed for Enterprise Portals such as SharePoint 2007. By having its own JavaScript tracking agent, and identifying SharePoint's object model, CardioLog 2007 provides first class usage reports for SharePoint 2007.

http://www.intlock.com/intlocksite/ProductsAndServices/Cardiolog.asp

Sunday, October 28, 2007 4:49 PM by Ronen Meyuhas

# re: SharePoint Reporting Solution

CardioLog 2007 by Intlock is a web analytics solution designed for Enterprise Portals - including SharePoint 2007. It has its own JavaScript tracking agent and identifies SharePoint's object model - to provide first class usage reports:

http://www.intlock.com/

Sunday, November 11, 2007 4:49 PM by Joel Oleson's Blog SharePoint Land

# Web Usage Reporting Tools

After my initial post on usage reporting I came across a few usage tools that I wanted to share. I have

Monday, January 12, 2009 1:54 AM by layali's blog

# Very Important Enterprise Search links

Module 1: BPIO workshops: https://www.msbpio.com/Pages/Default.aspx Quick Start for Microsoft Search:

Leave a Comment

(required) 
required 
(required) 
 
Page view tracker