Friday, 17 June 2011

Advance usage analysis for a SharePoint 2007 Site

Hi Friends and Neighbours,

MOSS 2007 have an advanced usage analysis report for site collection. These features are not turn on by default. We, as consultant, need to do this as part
of the installation or support procedure. These features will empower our clients to have access to stats report of their sites.


Using SharePoint(MOSS only) in-built usage report feature

SharePoint(MOSS version) lets you to view usage analysis reports for a site collection.Check that the following setting are turned on bLink home site collection:

1) In Shared Services Providers "Advanced usage analysis processing" should be enabled.
2) In Central Administration < Operation , "enable logging and usage analysis processing" should be enabled

Using LogParser


If these features are disabled on the target SharePoint collection, usage stats can be collected from IIS.
Remember that any SharePoint site run on top of IIS.

The Dark side of the Force has a mighty weapon on its disposal to query any log produced by Windows:

Log parser is a powerful, versatile tool that provides universal query access to text-based data such as log files, XML files and CSV files, as well as key data sources on the Windows operating system such as the Event Log, the Registry, the file system, and Active Directory

You can download LogParser by clicking on this link: Download it

There are different stats which can be generated by using different LogParser queries:







Top bandwidth usage by URL  SELECT top 50 DISTINCT  SUBSTR(TO_LOWERCASE(cs-uri-stem), 0, 55) AS Url,  Count(*) AS Hits,  AVG(sc-bytes) AS AvgBytes,  SUM(sc-bytes) as ServedBytes  FROM {filename}  GROUP BY Url  HAVING Hits >= 20  ORDER BY ServedBytes DESC url                                                   hits  avgbyte  served -------------------------------------------------     ----- -------  ------- /favicon.ico                                          16774 522      8756028 /content/img/search.png                               15342 446      6842532  



You can find some LogParse queries by following this link