Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


Enabling and Using Usage Analysis Reporting in MOSS 2007

By:   |   Updated: 2011-02-08   |   Comments   |   Related: > Sharepoint


SharePoint facilitates creating and managing many kinds of enterprise level web applications. It can be quite complex to trace and analyze application usage. Let's learn how to enable and find the built in usage reporting...


Therefore it is important to understand how to find usage analysis reporting, and if necessary, enabling it. Usage analysis reporting facilitates one to track page usage, requests and more.

In this tip, we will discuss how to enable usage reporting and how to view it.

To view site usage reports, Go to Site Actions -> Site settings


Click on "Site collection usage reports" under Site Collection Administration.

site collection

It is quite possible that it prompts an error describing that usage logging service must be enabled.

site collection usage

For enabling the service, go to Central Administration -> Operations -> Logging and Reporting -> Usage analysis processing.


Enable logging and enable usage analysis processing by ticking the box. Provide a time when to run the process to collect data of usage.

usage analysis

Click OK and go back to the site and check again usage analysis reporting. Now you can see different web parts showing different data descriptions like Requests per day, Top Pages and others. To view all the reports, logging needs "30 days" of site data.

site collection usage summary

Concluding on this, usage analysis reporting could be used for tracking sites, page and user accessing the site.

Next Steps
  • Use usage analysis reports to gather site access data.
  • Use such reports even to track users accessing sites.

Last Updated: 2011-02-08

get scripts

next tip button

About the author
MSSQLTips author Siddharth Mehta Siddharth Mehta is an Associate Manager with Accenture in the Avanade Division focusing on Business Intelligence.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


Learn more about SQL Server tools