In this section install and configure Microsoft Windows SharePoint Services monitoring and Data Collection, which will be used for reporting purposes.

Tasks

  1. Install the Windows SharePoint Services 3.0 Management Pack
  2. Install Monitoring Agents on COLLAB01 and COLLABBE01
  3. Enable SharePoint Usage Analysis Processing
  4. Grant the SharePoint_AppID User the db_owner Role for the PWDB40 Database
  5. Install the Windows SharePoint Services Data Collection Application
  6. Add OMAdminAccts group to the local Administrators group on each Windows SharePoint Services server

Install the Windows SharePoint Services 3.0 Management Pack

Procedure W03-DWSH.14: To install the Windows SharePoint Services 3.0 Systems Center Operations Manager management pack

  1. From the Solution Accelerator: SharePoint Monitoring Toolkit page, download the Windows SharePoint Services 3.0 System Center Operations Manager 2007 MP.msi installer.

  2. Run Windows SharePoint Services 3.0 System Center Operations Manager 2007 MP.msi. This will extract the management pack files into the C:\Program Files\System Center Management Packs\Windows SharePoint Services 3.0 System Center Operations Manager 2007 MP directory.

  3. Using the System Center Operations Manager console, import the Windows SharePoint Services 3.0 management pack from the C:\Program Files\System Center Management Packs\Windows SharePoint Services 3.0 System Center Operations Manager 2007 MP\Management Packs directory.

Install Monitoring Agents on COLLAB01 and COLLABBE01

Procedure W03-DWSH.15: To install monitoring agents on COLLAB01 and COLLABBE01

  1. Manually add the OMAction account to the local Administrators group on COLLAB01 and COLLABBE01.

  2. On OMMGR01, run the System Center Operations Console, and then navigate to Automatic Computer Discovery.

  3. Specify Fabrikam\Administrator as the administrator account.

  4. Select COLLAB01 and COLLABBE01 you want to manage (and have the monitoring agent installed on).

  5. At the Summary / Agent Action Account screen, accept the default agent installation directory. Specify the Fabrikam\OMAction account as the Agent Action account.

Enable SharePoint Usage Analysis Processing

By default, Windows SharePoint Services is not configured to enable usage analysis processing. Enable this using SharePoint Central Administration on COLLAB01.

Procedure W03-DWSH.16: To enable SharePoint usage analysis processing

  1. On COLLAB01, in SharePoint Central Administration, click Operations, and then under Logging and Reporting, click Usage analysis processing.

  2. Select Enable Logging. Then select Enable usage analysis processing. Leave the default times selected for Run processing between these times daily.

Grant the SharePoint_AppID User the db_owner Role for the PWDB40 Database

The SharePoint_AppID user account needs to be able to write data to the PWDB40 database for reporting purposes. Grant the SharePoint_AppID db_owner role to the PWDB40 database using the SQL Server Management Studio on OMSQL01.

Procedure W03-DWSH.17: To grant the SharePoint_AppID user the db_owner role for the PWDB40 database on OMSQL01

  1. On OMSQL01, open Microsoft SQL Server Management Studio and expand OMSQL01.

  2. Create a new login with the following information:

    • Login name: FABRIKAM\SharePoint_AppID
    • User mapping database: PWDB40
    • Database role: db_owner

Install the Windows SharePoint Services Data Collection Application

The Windows SharePoint Services data collection tool is an executable program (HSCollectWSSV3Data.exe) that you install on COLLAB01. You need to install the tool, and then create a scheduled task to run the tool.

Note:
The data collection tool only needs to be installed to the COLLAB01 server as long as all Windows SharePoint Services sites are load-balanced across all servers. Install this component on any server hosting unique sites.

Procedure W03-DWSH.18: To install the Windows SharePoint Services data collection application

  1. On COLLAB01, from the solution installation media \Monitoring and Reporting\ directory, run HSCollectWssV3Data.msi.

  2. Accept the default installation folder and perform the installation for Everyone.

Procedure W03-DWSH.19: To create a scheduled task to run the data collection application

  1. On COLLAB01, create a Scheduled Task with the following options:

    • Schedule: Daily at 1:05 AM
    • Command line: "C:\Program Files\Microsoft Hosting\Reporting\WSSV3 Data Collection\HSCollectWSSV3Data.exe" -d PWDB40 -s OMSQL01
    • Account to execute as: Fabrikam\SharePoint_AppID

  2. Ensure that the Fabrikam\SharePoint_AppID has write permissions to the C:\Program Files\Microsoft Hosting\Reporting\WSSV3 Data Collection folder.

Add OMAdminAccts group to the local Administrators group on each Windows SharePoint Services server

Procedure W03-DWSH.20: To Add OMAdminAccts group to local Administrators group on each Windows Sharepoint Services server

  1. On each Windows SharePoint Services server, open the Computer Management console.

  2. Add OMAdminAccts to the local Administrators group.