Usage Analysis Report in SharePoint Portal
 
Published: 08 Aug 2006
Unedited - Community Contributed
Abstract
Most users are confused about how to get a Usage Analysis Report in a SharePoint Portal. On the WSS site you do have a link, but how do you do this on a SharePoint Portal? This article explains on how to display the Usage Analysis report to users.
by Ameet Phadnis
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 55381/ 108

Introduction

Companies generally tend to keep track of who is accessing their websites and what pages were accessed by the users.  These reports are used to determine the most used pages, the least used pages, etc.  This helps in determining which pages can be removed from the Web site or which pages need to be highlighted.

In the Intranet world Managers of different departments are interested in knowing what users are interested in on their pages.  Based on the documents or sub areas accessed by the employees, individual departments can decide to publish the content on the main page for easy navigation for users.

In normal Web Site there are different tools that assist you in tracking the Site Usage.  These reports may contain the following information.

·         Users that have accessed the site

·         When the users accessed the sit

·         What pages were used on the site

The list can go on and on.

SharePoint Portal also tracks the usage of the sites.  This article explains how SharePoint tracks and reports the site's use.

Setting SharePoint to Log Usage Analysis

The first step is to setup SharePoint to track the Usage Analysis Report.

The steps are as follows.

·         On your site, click Site Settings.

Figure 1

·         On Site Settings under the General Settings, click on Go to SharePoint Portal Server Central Administration.

·         On the SharePoint Portal Server Central Administration page under Component Configuration, click on Configure Usage Analysis Processing.

Figure 2

·         The configure Usage Analysis Screen is displayed.

Figure 3

·         Administrators can set the following settings on this screen.

·         Enable Logging - This should be checked if you want to use the Usage Analysis Report.  Log files are created daily on the server.  These log files track the Usage information.

·         Log File Location - Where the Log files need to be stored.  By default it is stored under c:\%windir%\system32\LogFiles\STS.  Under this folder are contained folders for each virtual server and under these folders are folders for each day.  Administrators can change this location path to something else.  If you choose to change this path to some other folder make sure that STS_WPG group has Read, Write and Update permissions to the site.

·         Time for Processing the Usage Logs - Generally, you should schedule the time for processing the logs when the usage of the site is at a minimum.  In the intranet world it would make sense to process the Usage Logs at night when the site is not being used much by employees.  By default, the time is set to 1 am to 2 am.

·         Make the necessary changes on this screen and click ok.

With the above administration process, you have just setup the Website to track the Usage Analysis for SharePoint Sites.

Log Folder structure and its contents

Before we move into how to display the Usage Analysis Report, let us first look at the log folder structure and the log files.

Typically your Log Folders will look like Figure 4.

Figure 4

You will notice it is tracking a Log report for different virtual servers and under each server it has folders for each day.  If you click on any of those day folders you will see a log file like the following.

Figure 5

The log files are just plain text documents.  If you open one of these log files you should see lines similar to the following:

D6B48D8C-76AA-4A61-88B7-29D987E67D2E 15:13:46 http://etekglobal  default.aspx aapw2003sharepo\administrator   Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.2; .NET CLR 1.1.4322)     

This line information gives you an idea of what time the person has logged in and what pages were visited, etc.  In the above scenario it displays that the administrator logged onto the intranet site and the page visited was the default page.

WSS and SharePoint Usage Analysis Report

Before looking at how we can view the report on SharePoint Portal, let us see how we can view the report on the WSS site.

On WSS follow these steps to display the report.

·         Click on Site Settings.

Figure 6

·         Under Administration, click on the Site Administration link.

Figure 7

·         Under Management and Statistics, click on View Site Usage data.

·         The report will be displayed to you.

Sounds easy enough in the WSS site, but is it that simple on SharePoint Portal?  Yes, but there is no link provided as it is provided on the WSS site.

The SharePoint developers/administrators need to understand one important thing about SharePoint Portal: it is a collection of WSS sites.  SharePoint is built on top of WSS sites.  Once you have understood this basic principal, you will understand that you can use some of the pages in a WSS site on SharePoint portal too.

So, in order to display the report you need to use the following syntax for your sub areas.  As SharePoint Portal is made up of sites collection, you can go to any sub area you are interested in and type the path for Usage Analysis Report page.  The syntax would be: <website>/<sub area>/_layouts/1033/usageDetails.aspx.  For example, in my scenario for etekglobal website home area, it would be http://etekglobal/_layouts/1033/usageDetails.aspx.  The way I got this syntax was to copy everything starting from _layouts from the address bar on the WSS usage analysis report.  So, when the administrators would like to run reports for each sub area they can just go to the sub area and instead of using the default.aspx, they can just paste everything beginning with _layouts.  That is all!  You now have a running Usage Analysis Report.

What does the report contain?

Finally, I would like to sum up what the report contains.  The Usage Analysis Report reports on Page Usage, Users Logs, OS, Browser and Referrer URL.  All the reports can be run on a Month or Daily summary.  The month summary will list usage for last 30 days from the date the report was run and daily report will report on daily usage for the last 30 days.   Typically the report will look as follows.

 

Figure 8 Month Summary Report

 

Figure 9 Daily Report

 

Summary

Finally, the main thing to understand is that what you are able to do on WSS can be done in SharePoint Portal, but the developer has to tweak it to make it work.  There are a lot of backdoors like this one in SharePoint Portal.  It simply takes some playing around in SharePoint to figure out these backdoors.



User Comments

Title: NIKE NFL jerseys   
Name: NIKE NFL jerseys
Date: 2012-07-02 10:08:57 AM
Comment:
http://www.jersey2shop.com
http://www.cheapjersey2store.com
http://www.jerseycaptain.com
http://www.yourjerseyhome.com
We are professional jerseys manufacturer from china,wholesal.cheap nike nfl jerseys, mlb jerseys, nhl jerseys,nba jerseys and shoes
Cheap NFL,NBA,MLB,NHL
,heap jerseys,2012 nike nfl Jerseys,nba jersey and shorts,oklahoma city thunder jersey,official jeremy lin new york knicks jersey,NFL Jerseys Wholesale,blake griffin jersey blue,NFL jerseys For Sale online.All Our Jerseys Are Sewn On and Directly From Chinese Jerseys Factory
,Wholesale cheap jerseys,Cheap mlb jerseys,]Nike NFL Jerseys,Cheap China Wholesae,Wholesale jerseys From China,2012 nike nfl Jerseys,Jerseys From China,,2012 nike nfl Jerseys,Revolution 30 nba jerseys,jersey of nba chicago bulls direk rose ,nfl jerseys,green bay packers jerseys wholesale,Buffalo Bills nike nfl jerseys sale,good supplier soccer jerseys,cool base mlb jerseys,Revolution 30 nba jerseys,2012 stanley cup nhl jersey,
We are professional jerseys manufacturer from china,wholesal.cheap nike nfl jerseys, mlb jerseys, nhl jerseys,nba jerseys and shoes. www.yourjerseyhome.com
Title: SharePoint Usage   
Name: CardioLog
Date: 2010-10-17 12:42:33 PM
Comment:
I recommend using CardioLog for tracking SharePoint Usage data. With CardioLog, not only will you be able to determine the most used pages, the least used pages, but you will also have in-depth insight into portal growth, portal visitors, portal navigation and search. They have a free 30 day Enterprise trial so you can test out the product before buying.

CardioLog.... http://www.intlock.com/
Title: Need help   
Name: Kris
Date: 2010-08-23 2:33:21 AM
Comment:
I need to show top 5 users of the site but without adding any performance hit.

Thanks
Kris
http://www.koolkoolkris.blogspot.com
Title: Displaying this as Number.   
Name: SharePoint Usage Reports
Date: 2008-08-26 7:31:36 AM
Comment:
I would like to know one thing. Is it possible to display the number of hits to the main site in the form of just the Number:
like,
No: of Hits : 1500

Please let me know at : nimeshprabhakar@gmail.com
Title: Not able to get through   
Name: Aman Kumar
Date: 2008-01-30 5:21:17 PM
Comment:
after enablig i'm still geeting an error Both Windows SharePoint Services Usage logging and Office SharePoint Usage Processing must be enabled to view usage reports. Please contact your administrator to ensure that these services are enabled.

Please do mail me at amanself007@gmail.com

Thanks
Title: Sites Usage Report   
Name: Kiran
Date: 2007-07-31 8:48:56 PM
Comment:
The article was of great help. Is there a way to get report of all the users who have logged on to any 1 of the wss sites for a given date range
Title: Thank You   
Name: Rajesh
Date: 2007-07-27 2:33:25 AM
Comment:
Hi,

This article was of a great help to me. This could have been even better if you could tell how to keep track of User-Website-Number of Hits. Yes this covers User and Number of Hits, but leaves blank which website was browsed.

Rajesh
raj4dw@gmail.com
Title: Customizing Site Usgage Reports.   
Name: Kalpesh
Date: 2007-05-29 1:58:31 PM
Comment:
How can I customize the site usage report. For an example if I wish to show the username instead of userid in usage report?
Title: More interesting and needed report   
Name: Alex
Date: 2007-03-15 6:06:33 AM
Comment:
It would be interesting to have a report that shows data all over the portal, i.e. it is interesting to know what pages are the most visited in the whole portal.

Product Spotlight
Product Spotlight 





Community Advice: ASP | SQL | XML | Regular Expressions | Windows


©Copyright 1998-2019 ASPAlliance.com  |  Page Processed at 2019-11-17 2:53:06 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search