Install and Configure System Center Management Pack for SharePoint Server 2013

Standard

In this post I’m going to take you true the steps I took to install and configure the system center management pack for SharePoint server 2013. Before installing the system center management pack for SharePoint server 2013 let’s take a look ad the environment that I want to monitor

  • 2 SharePoint Web Front-End servers
  • 1 SharePoint Application server
  • 2 Microsoft SQL 2012 server

You can download the system center management pack for SharePoint server 2013 from here

Before you start installing the system center management pack for SharePoint 2013 make you sure you have installed and configured the following management pack’s:

  • System Center Management Pack for Windows Server Operating System which can be downloaded from here
  • Microsoft System Center Management Pack for SQL Server which can be downloaded from here
  • System Center 2012 Management Pack for Microsoft Windows Server 2012 Internet Information Service 8 which can be downloaded from here

I took the following steps

  1. Install the system center management pack for SharePoint 2013
  2. Import the system center management pack for SharePoint 2013
  3. Copy the configuration file
  4. Create a Run-As account
  5. Give the Run-As account full access to the SQL Servers 
  6. Give the Run-As account farm admin rights to your SharePoint environment
  7. Configure the SharePoint config file
  8. Configure the SharePoint management pack

1. Install the system center management pack for SharePoint 2013

  1. Click "Microsoft.Sharepoint.Server.ManagementPacks.msi"
  2. In the “Microsoft.SharePoint.Server.ManagementPacks – installer” wizard, on the “License Agreement” page, select “I accept” and click “Next
    Install SharePoint Server Management Pack
  3. In the “Microsoft.SharePoint.Server.ManagementPacks – installer” wizard, on the “Select Installation Folder” page, select “Everyone” and click “Next
    Install SharePoint Server Management Pack
  4. In the “Microsoft.SharePoint.Server.ManagementPacks – installer” wizard, on the “Confirm Installation” page, click “Install
    Install SharePoint Server Management Pack
  5. In the “Microsoft.SharePoint.Server.ManagementPacks – installer” wizard, on the “Installation Complete” page, click “Close
    InstallSharePointMP4

2. Import the system center management pack for SharePoint 2013

  1. Start the "Operations Manager Console"
  2. In the “Operations Manager Console” click “Administration
  3. Right click “Management Packs”, and the click “Import Management Packs
    Import Management Packs
  4. The “Import Management pack wizard” opens. Click “Add”, and the click “Add from Disk
    Import Management Packs
  5. The Select Management Packs to import dialog box appears. If necessary, change to the directory that holds your management pack file. Select the following files:
    • Microsoft.SharePoint.Foundation.Library.mp
    • Microsoft.SharePoint.Foundation.2013.Discovery.mp
    • Microsoft.SharePoint.Foundation.2013.Monitoring.mp
    • Microsoft.SharePoint.Server.Library.mp
    • Microsoft.SharePoint.Server.2013.Discovery.mp
    • Microsoft.SharePoint.Server.2013.Monitoring.mp
      Import Management Packs
  6. In the “Import Management Pack” wizard, Click “Install
  7. In the “Import Management Pack” wizard, Click “Close

3. Copy the configuration file

  1. Make a RDP connection to your “Management Server
  2. From the directory “C:\Program Files (x86)\System Center Management Packs\Microsoft.Sharepoint.Server.ManagementPacks” copy the file “microsoft.sharepoint.foundation.library.mp” with the type config to the directory “C:\Program Files\System Center Management Packs

4. Create a Run-As accounts

  1. Start the “Operations Manager Console
  2. In the "Administration" Workspace, in the Navigation pane, expand "Run As Configuration", right click "Accounts" and click "Create Run As Account"

    Create Run As Account

  3. In the “Create Run As Account Wizard”, on the “Introduction” page, click “Next
  4. In the “Create Run As Account Wizard”, on the “General Properties” page enter the following “Display Name” “SharePoint Discovery/Monitoring Account” and click “NextCreate Run As Account
  5. In the “Create Run As Account Wizard”, on the “Credentials” page enter the “Username”, “Password”, “Confirm password”, “Domain” and click “Next
    Create Run As Account
  6. In the “Create Run As Account Wizard”, on the “Distribution Security” page, select “More Secure” and click “Create
    Create Run As Account
  7. In the “Create Run As Account Wizard”, on the “Completion” page, click “Close
  8. Right click on the “SharePoint Discovery/Monitoring Account” and click “Properties
    Create Run As Account
  9. On the “Run As Account Properties – SharePoint Discovery/Monitoring Account” page open the tab “Distribution
    Create Run As Account
  10. On the “Run As Account Properties – SharePoint Discovery/ Monitoring Account” page on the “Distribution” tab, click  “Add”  to add all the SharePoint farm computers.
    Create Run As Account
  11. On the “Run As Account Properties – SharePoint Discovery/Monitoring Account” page, on the “Distribution” tab click “Apply” and the “OK

5. Give the Run-AS accounts full access to the SQL Servers 

  1. Make a RDP connection to your “SQL Server” hosting your SharePoint databases
  2. Start the “Server Manager
  3. In the “Server Manager” in the tools menu click “Computer Management
    SQL Computer Management Local User
  4. On the “Computer Management” page, expand “Local Users and Groups” and click “Groups
  5. On the “Computer Management” page, open the “Administrators” group
    SQL Computer Management Local User
  6. On the “Administrators Properties” page click “Add” and add the user you used to create your Run As account.
  7. On the “Administrators Properties” page click “Apply” and click “OK
  8. On the SQL server start the “Microsoft SQL Server Management Studio
    SQL Full Access Database
  9. In the “Connect tot server” page enter the “Server name” your “Authentication” and click “Connect
  10. In the “Object Explorer” expand “Security”, and right click “Logins” and click “New Login
    SQL Full Access Database
  11. On the “New Login” page, on the “General” page add the above created account
    SQL Full Access Database
  12. On the “New Login” page, on the “Server Roles” page, select “Sysadmin” and click “Ok
    SQLFullAccess6
  13. Repeat the above steps on all your SQL Servers.

6. Give the Run-As account farm admin rights to your SharePoint environment

I am not a SharePoint  administrator so I contacted my SharePoint Administrator to give the monitoring account farm admin right to the SharePoint farm.

7. Configure the SharePoint config file

  1. Open the “microsoft.sharepoint.foundation.library.mp.config” SharePoint configuration file from the following location: “C:\Program Files\System Center Management Packs
  2. In edit the following rule:
    <Association Account="SharePoint Discovery/Monitoring Account" Type="Agent">
        <Machine Name="" />
    </Association>
  3. add a “Machine Name” line for each server in your farm. I have 5 servers that are in my farm so my Config file looks something like this:
    <association type="Agent" account="SharePoint Discovery/Monitoring Account">
        <machine name="web01.ms-opsmgr.eu" />
        <machine name="web02.ms-opsmgr.eu" />
        <machine name="sql01.ms-opsmgr.eu" />
        <machine name="sql02.ms-opsmgr.eu" />
        <machine name="app01.ms-opsmgr.eu" />
    </association>
  4. Save and close the configuration file

8. Configure the SharePoint management pack

  1. Start the “Operations Manager Console
  2. In the “Monitoring” workspace expand “”Microsoft SharePoint” and select “Administration” and from the administration pane select “Microsoft SharePoint Farm Group

    SharePoint Configuration

  3. From the “Tasks” pane, click “Configure SharePoint Management Pack

    Sharepoint Configuration

  4. On the “Run Task – Configure SharePoint Management Pack” click “Run

    SharePoint Configuration

  5. The result should look something like this:

    Sharepoint Configuration

    When everything is finished the result should look something like this.

    Finished

    When you want more information of installing and configuring the SharePoint Management pack please take a look at:

    Log file Monitoring with the FREE NiCE Management Pack

    Standard

    In this blogpost I am going to take you true the steps I took to install and configure the Nice Log File Management Pack. You can download the management pack from here and the best thing is that is for FREE!!

    NiCE Log File Monitoring

    Scenario:

    I have an device which generates a log file entry when a registration is received. The registration is processed by an application. I going measure the performance of the application by calculating the time between registration and the processing the information in the application.

    1. Install the Management Pack
    2. Import the Management Pack
    3. PowerShell script to calculate the time between registration and processing
    4. Create a Management Pack.
    5. Create a performance rule using the NiCE Management Pack
    6. Create a performance view

    1. Install the Management Pack

    1. Run the "NiCE_LogfileMP_0130.msi"
    2. In the "NiCE Log File MP – InstallShield Wizard" on the "Welcome to the InstallShield Wizard for NiCE Log File MP" page, click "Next"
      NiCE Log File MP - InstallShield Wizard
    3. In the “NiCE Log File MP – InstallShield Wizard” on the “License Agreement” page, check “I accept the terms and in the license agreement” and click “Next
      NiCE Log File MP - InstallShield Wizard
    4. In the “NiCE Log File MP – InstallShield Wizard” on the “Destination Folder” page, click “Next
      NiCE Log File MP - InstallShield Wizard
    5. In the “NiCE Log File MP – InstallShield Wizard”, on the “InstallShield Wizard Completed” page, click “Finish
      NiCE Log File MP - InstallShield Wizard

    2. Import the Management Pack

    1. Start the "Operations Manager Console"
    2. In the “Operations Manager Console” click “Administration
    3. Right click “Management Packs”, and the click “Import Management Packs
      Management Packs
    4. The “Import Management pack wizard” opens. Click “Add”, and the click “Add from Disk
      Import Management Packs
    5. The Select Management Packs to import dialog box appears. If necessary, change to the directory that holds your management pack file. Click one or more management packs to import from that directory, and then click Open.
      Select Managemetn Packs to Import
    6. In the “Import Management Pack” wizard, Click “Install
    7. In the “Import Management Pack” wizard, Click “Close

    3. PowerShell script to calculate the time between registration and processing

    I’ve create the following PowerShell script:

    The new created log file looks like this

    Powershell Script Result

    4. Create a Management Pack

    1. Start the “Operations Manager Console
    2. In the "Administration" Workspace, in the Navigation pane, right click "Management Pack" and click "Create Management Pack"

      Create Management Pack

    3. In the “Create a Management Pack” wizard, on the “General properties” page, give the management pack a name and click “Next
    4. In the “Create a Management Pack” wizard, on the “Knowledge Article” page, click “Create

    5. Create a Performance Rule Using NiCE Management Pack

    1. Start the “Operations Manager Console
    2. In the “Authoring” Workspace, in the navigation pane, right click “Rules” and select “Create a new Rule

      Create Performance Rule

    3. In the “Create Rule Wizard”, on the “Rule Type” page, expand “NiCE Log Files”, expand “Performance Rules”, expand “Advanced”, expand “Expression filtered” and then click “Performance Rules (Advanced)

      Create Perfomance Rule

    4. In the “Create Rule Wizard”, on the “Rule Type” page, select the Management pack created in step 4
    5. In the “Create Rule Wizard”, on the “Rule Type” page, Click “Next
    6. In the “Create Rule Wizard”, on the “General” page, In the “Rule name” page enter a “Name”, In the “Rule Category” select “Performance Collection”. Next to “Rule Target” click “Select” and the select the target “Windows Server 2012 R2 Computer”, click “Next

      Create Performance Rule

    7. In the “Create Rule Wizard” on the “Pre-processing Settings” page, click “Next

    8. In the “Create Rule Wizard” on the “Log file Source Settings” page, In the “Log file Path” enter the locations off the log file, In the “Log file Name” click enter the log file name you want to monitor and click “Next

      Create Performance Rule

    9. In the “Create Rule Wizard” on the “Regular Expression Settings (Optional)”, start the “Regex Testing tool
    10. In the “Regex Testing Tool” in the “Log file Line” enter a line of the log file and create a Regex. Mine looked something like this:

      CreatePerformanceRule5

    11. In the “Regex Testing Tool” click “OK
    12. In the “Create Rule Wizard” on the “Regular Expression Settings (Optional)” page, click “Next

      Create Performance Rule

    13. In the “Create Rule Wizard” on the “Performance Mapper” page, In the “Object” field enter “$Target/Property[Type="MicrosoftWindowsLibrary7585010!Microsoft.Windows.Computer"]/HostServerName$”, In the ”Counter” field enter “Time”, In the “Instance” field enter “Val”, In the “Value” field enter “$Date/RegexMatch/Val$

      Create Perfomance Rule

    14. In the “Create Rule Wizard” on the “Performance Mapper” page click “Create

    6. Create Performance View

    1. Start the “Operations Manager Console
    2. In the  “Operations Console”, select “Monitoring” and expand the management pack that you created.
    3. Right click “Management Pack” and click “New” and click “Performance View

      Create Performance View

    4. On the “Properties Name” page, Enter a “Name” check “Collected by Specific rules” and in the Criteria description select the above created “Performance Rule” It should look something like this:

      Create Performance View

    5. The result should look something like this:

      Create Performance View

    This Management Pack will provide capabilities which are missing in System Center Operations manager and the best part off it it’s free. I advice you to check there website and try there management pack.

    I would like to thank Thando Chasakara and his support team for answering all the questions that I had when started working whit the management pack

    Update MP: Microsoft Exchange Server 2013 Management Pack

    Standard

    On 28-April-2015 Microsoft released update for the Microsoft Exchange Server 2013 Management Pack. The version is updated to 15.0.066.20

    • Microsoft Exchange Server 2013 Management Pack The features and fixes that are included in this update:
      • Fix: preventing Exchange 2013 Mailbox Properties collection when the contents of Email Addresses field exceed the total length of more than 1024 characters.
      • Fix: alerts generated by the previous version of the Management Pack for Exchange Server 2013 have unreadable name. After upgrading of the Management Pack to version 15.0.620.19, alerts generated before the upgrade had the following name: {2}

    Before installing in the updates in your production environment make sure that you test these updates in your test environment.