The SQL Server Report Pack for SPS 2003


In cased you missed it - A very cool tool!


The Microsoft® SQL Server Report Pack for Microsoft® Office SharePoint® Portal Server 2003 is a set of predefined report definition files that work with a sample database of information extracted from a SharePoint Portal Server environment. The sample database can be populated from your own SharePoint Portal Server environment using the included Data Extraction Program (DEP). The DEP will read the SharePoint Portal Server data via the object model and will also parse the Microsoft Windows® SharePoint Services and Microsoft Internet Information Services (IIS) logs (the IIS logs are parsed using the downloadable IIS Log Parser).  You can use the sample reports “as-is” or as templates for designing new reports. 


 


There are eight predefined reports that cover the search, site trend and content storage functions of the SharePoint environment. These reports provide a proactive means for monitoring the status of their SharePoint Portal Server environment. The site trend and content storage provide insight into the growth and allocation of server content. With this information an administrator can predict the need for more database and hard drive storage. The search reports provide keen insight into what words and phrases are being used in search. These keywords can be used to tune the best bets and keywords, as well as suggest ways to improve the overall navigation of their portal deployments.


The following table outlines the reports:


 









































Area


Report Name


Description


Storage


Storage Report


Shows a listing of the virtual servers and the number of collections, sites, areas, lists, files and size.  There is also a size distribution and storage usage chart, and a top 20 sites based on size.  You can click through the virtual server to go to the Storage Trend Report.


 


Storage Trend Report


Shows four charts illustrating the virtual server storage trend, site collection growth trend, area growth trend and list growth trend.


Hit Trends


Site Trend Report


Shows hit counts for virtual servers, collections, areas and lists.  Also shown are the top 20 sites based on hits.  You can click through the virtual server to go to the Comprehensive Site Collections Report.


 


Comprehensive Site Collections Report


Shows the list of site collections, who owns the collection, configurable characteristics about the owner and the date the collection was last accessed.  You can click on a site collection to go to the Detailed Site Collection Report.


 


Detailed Site Collection Report


Shows top 20 pages accessed (based on hit count) for this site collection.  You can click on a page to go to the Detailed Page Report.


 


Detailed Page Report


Shows users who have access this page, when they last accessed it, any referrer URL and number of hits.  Also shown are two charts illustrating user distribution and referrer distribution.


Search


Best Bet Keyword


Shows top 20, top 10, bottom 10 or bottom 20 keywords used for searching.  It also shows which keywords have best bets.


 


Search Terms


Shows top 20, top 10, bottom 10 or bottom 20 search terms used for searching.  It also shows which search terms match a defined keyword.


 


Download the report pack from:
http://www.microsoft.com/downloads/details.aspx?FamilyId=49159368-544B-4B09-8EED-4844B4E33D3D&displaylang=en


 


Download the IIS Log Parser:


http://www.microsoft.com/technet/scriptcenter/tools/logparser/default.mspx


 


 

Comments (4)

  1. August

    2005 issue of MSDN Magazine now online [Via: toub ]

    Breaking

    News: New Microsoft Certification…

  2. August

    2005 issue of MSDN Magazine now online [Via: toub ]

    Breaking

    News: New Microsoft Certification…

  3. Rachael Martino says:

    Thom,

    I was just installing this on my SPS server, and it needs VS.Net 2003 to install. Do we have to have VS on our servers in order to run the reports?

Skip to main content