Learn more about SQL Server tools

mssqltips logo
 

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

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Enabling and Using Usage Analysis Reporting in MOSS 2007


By:   |   Read Comments   |   Related Tips: > Sharepoint

Attend this free live MSSQLTips webcast

Tips and Tricks to Growing Your SQL Server Estate from SMB to Enterprise Scale
Thursday, June 28, 2018 - click here to learn more


Problem

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...

Solution

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

create

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.

operations

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 Update:


next webcast button


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