Servers

    Microsoft SQL Server Report Pack for Microsoft Office SharePoint Portal Server 2003

    Language:
    English
    A set of 8 reports that work with a sample database of information extracted from a SharePoint Portal Server environment.
    • Version:

      1.0

      File Name:

      SQLReportPackSPS.msi

      Date Published:

      8/29/2005

      File Size:

      28.4 MB

        The Microsoft SQL Server Report Pack for Microsoft Office SharePoint Portal Server 2003 is a set of 8 Microsoft SQL Server 2000 Reporting Services reports that work with a sample database of information extracted from a SharePoint Portal Server environment. This database can be populated from your own SharePoint Portal Server environment using the downloadable Data Extraction Program (DEP). The DEP will read the SharePoint Portal Server data via the object model. You also can use the sample reports as templates for designing new reports.
        This Report Pack includes the following reports:

        • Storage Report
          Shows a listing of the virtual servers and the number of collections, sites, areas, lists, files and size. Also shows a size distribution and storage usage chart, and a top 20 sites based on size.
        • Storage Trend Report
          Shows four charts illustrating the virtual server storage trend, site collection growth trend, area growth trend and list growth trend.
        • Site Trend Report
          Shows hit counts for virtual servers, collections, areas and lists. Also shows the top 20 sites based on hits.
        • 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.
        • Detailed Site Collection Report
          Shows top 20 pages accessed (based on hit count) for this site collection.
        • Detailed Page Report
          Shows users who have access to the page, when they last accessed it, any referrer URL and number of hits. Also shows two charts illustrating user distribution and referrer distribution.
        • Best Bet Keyword
          Shows top 20, top 10, bottom 10, or bottom 20 keywords used for searching. Also shows which keywords have best bets.
        • Search Terms
          Shows top 20, top 10, bottom 10, or bottom 20 search terms used for searching. Also shows which search terms match a defined keyword.

        Note: If you encounter a System.Data.SqlClient.SqlException error message when running the Data Extraction Program (DEP) RPDataExtraction.exe, see Knowledge Base article 906508.

        Note: This software is licensed “as-is.” It is not supported, and you bear the risk of using it. Microsoft gives no express warranties, guarantees or conditions.
    • Supported Operating System

      Windows 2000 Advanced Server, Windows 2000 Professional Edition , Windows 2000 Server, Windows Server 2003, Windows XP Professional Edition

        • Microsoft Office SharePoint Portal Server 2003

        • Microsoft SQL Server 2000 SP3a or later with the dbSPSReportingStaging and dbSPSReporting SQL Server databases installed (for SharePoint Portal Server Report Pack reports)

        • Microsoft SQL Server 2000 Reporting Services SP1 or later

        • Microsoft Internet Explorer 5.5 or later

        • Microsoft Visual Studio .NET 2003 with Report Designer installed (for uploading or modifying the reports)

        • LogParser.exe IIS log parser utility

        • SharePoint Portal Server Report Pack Sample Database: 25 megabytes

        • Sample Reports: 700 kilobytes

        1. Download the file by clicking the Download link (above) and saving the file to your hard disk.

        2. Launch the SQLReportPackSPS.msi program file on your hard disk to start the setup program.

        3. Follow the instructions on the screen to complete the installation.

        4. Additional setup instructions are provided in the accompanying Readme file.


    Popular downloads

    Loading your results, please wait...

    Free PC updates

    • Security patches
    • Software updates
    • Service packs
    • Hardware drivers

    Microsoft suggests

    Download a free trial of Windows Server 2012 R2.
    Windows Server 2012 R2 free trial
    Experience the new and enhanced capabilities.
    Free trial