Usage Report in Sharepoint 2007

SharePoint 2007 has built in usage reports that can easily be enabled to allow site administrators and site collection administrators to monitor statistics about the use of their sites. These reports are NOT turned on by default when install MOSS 2007.

Sharepoint has usage reporting feature , this will be handy for the basic usage reporting.This feature is there in sharepoint but we need to enable them to start reporting.One of the drwaback of this reporting it supports only 30 days.

This report could be filtered by the following criteria.

• Page
• Browser
• Referrer URL
• User
• Operating System

If you are sharepoint admin you will be intrested in following information from Usage Report

• Total hits and recent bandwidth usage across all sites.
• Maximum storage space allowed.
• Total amount of storage used by the site collection.
• Percent of storage space used by Web Discussions.
• Number of users for all sites in the hierarchy.

Three Quick Steps to Configure Site Usage Reporting

1. Enable Usage Logging in Central Administration
   

   A. On the Central Administration home page, click                Operations.

   B. On the Operations page, in the Logging and Reporting section, click Usage analysis processing.

   C. On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging.

   D. Type a log file location and number of log files to create.

   E. In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing.

2. Enable Usage Reporting on SSP Admin Page
   

   A. On the SSP home page, in the Portal Usage Reporting section, click Usage reporting.

   B. On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing.

   C. In the Search Query Logging section, select Enable search query logging.

3. Activate the Reporting Feature for the Site Collection
   

   A. On the Site Actions menu, click Site Settings.

   B. On the Site Settings page, in the Site Collection Administration section, click Site collection features.

   C. On the Site Collection Features page, click the Activate button for the Reporting feature.

IMPORTANT: You must also enable Office Sharepoint Server Standard Site and Collection Features if you have not already done this. The sharepoint server that I inherited did not have this turned on, so reporting did not work.

4. Activate the Office SharePoint Server Standard Site Collection Features
   

   A. On the Site Actions menu, click Site Settings.

   B. On the Site Settings page, in the Site Collection Administration section, click Site collection features.

   C. On the Site Collection Features page, click the Activate button for the Office Sharepoint Server Standard Site Collection features.

5. Activate the Office SharePoint Server Standard Site Features ( This needs to be done on each site)
   

   A. On the Site Actions menu, click Site Settings, click Modify All Site Settings.

   B. On the Site Settings page, in the Site Administration section, click Site features.

   C. On the Site Collection Features page, click the Activate button for the Office Sharepoint Server Standard Site Collection features.

After site usage reporting is enabled the site administrators and site collection administrators will be able to view reports detailing:

• Requests and queries in the last day and the last 30 days
• Average number of requests per day over the last 30 days
• Requests per day over the last 30 days
• Top page requests over the last 30 days
• Top users over the last 30 days
• Top referring hosts over the last 30 days
• Top referring pages over the last 30 days
• Top destination pages over the last 30 days
• Top search queries for the last 30 days
• Search results top destination pages
• Number of search queries per day over the previous 30 days
• Number of search queries per month over the previous 12 months
• Top search queries over the previous 30 days
• Search Queries per search scope over the previous 30 days

Site collection administrators will be able to view reports detailing:

• Total amount of storage used by the site collection
• Percent of storage space used by Web Discussions
• Maximum storage space allowed
• Number of users for all sites in the hierarchy
• Total hits and recent bandwidth usage across all sites

Let see how we will enable this feature

1. Go To Central Administrative Site of Sharepoint Farm

2. Go To Operations Tab
3. In Operations Page Go To Logging And Reporting Section

4. Click On Usage Analysis Processing Link

5. In Usage Analyisis Page Enable Loging and set the Log Path

6. Enable Usage Analysis Processing and Set the time
7. Click OK and Save the settings

Now you are enabled analysis in you Farm, So the next step is to enable it in Shared Service level.

1. Go To Shared Service Home Page

2. Go To Office SharePoint Usage Reporting section, click Usage reporting
3. In Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing.

4. Search Query Logging section, select Enable search query logging


Now you could enable it in the Site Collection.
1. Go to the Root Site (Home page of your site)
2.Click on the settings ->Modify All settings

3. In Settings Page go to SiteCollection Administrative Section and click Site Collectin Features

4. In Feature Listing page Activate Reporting Feature

Let see How we can view this reports

1. Site administrators - Site Settings -> Site Administration section -> Site usage reports
2. SSP administration site - Site Settings -> Site Administration section -> Usage summary