Add a Dashboard View to a SharePoint Site

  • Article

Applies To: Operations Manager 2012

System Center 2012 – Operations Manager includes a SharePoint web part that displays selected dashboards from the Web console. A configured web part allows you to see at a glance the availability and performance metrics for applications in your environment. The web part is particularly useful for providing current status views to individuals in your organization who are not Operations Manager users.

In these procedures, you deploy the Operations Manager web part to a SharePoint site, configure the web part to connect to a web console, and then you add the web part to a SharePoint page. If you want to enable individuals who are not Operations Manager users to view the web part, configure the web part to use shared credentials.

This topic contains the following procedures:

  • Deploying the Web Part

  • Configuring the Web Part to Connect to a Web Console

  • Adding the Web Part to a Page

  • Configuring Shared Credentials

Deploying the Web Part

The following are the prerequisites for deploying the Operations Manager web part:

  • The Operations Manager web console must be installed on a management server.

  • The SharePoint farm must be running SharePoint Server 2010 Standard, SharePoint Server 2010 Enterprise, or SharePoint Foundation 2010.

    Note

    If the SharePoint farm is running SharePoint Foundation 2010, you can only deploy the web part in the same domain as the web console and you cannot use shared credentials.

  • You must have SharePoint administrator permissions for the SharePoint farm; specifically, you must have permissions to perform the following tasks:

    • Run the SharePoint PowerShell client

    • Start and stop the SPAdminV4 and SPTimerV4 services

    • Run the Add-SPSolution and Install-SPSolution cmdlets for the farm, and run the Enable-SPFeature cmdlet for all sites on the farm

The web part is a solution file named Microsoft.EnterpriseManagement.SharePointIntegration.wsp. To deploy the web part, you run a script named install-OperationsManager-DashboardViewer.ps1. This script is located in the Operations Manager installation folder under Setup\amd64\SharePoint.

Note

You can get more information on the scripts included with Operations Manager by using the command shell and the get-help cmdlet. For example: get-help install-OperationsManager-DashboardViewer.ps1.

Using the install-OperationsManager-DashboardViewer.ps1 script, you can deploy the web part to all sites and web applications in the farm or to a specific site or web application.

To deploy the Operations Manager web part

  1. Copy the install-OperationsManager-DashboardViewer.ps1 file from the Operations Manager installation folder under Setup\amd64\SharePoint to a location that the SharePoint 2010 Management Shell can access.

  2. Open the SharePoint 2010 Management Shell and navigate to the directory where you saved the install-OperationsManager-DashboardViewer.ps1 file.

  3. In the SharePoint 2010 Management Shell, type the following command, and then press Enter.

    .\install-OperationsManager-DashboardViewer.ps1 –solutionPath <directory for Microsoft.EnterpriseManagement.SharePointIntegration.wsp> -url <optional, for installing to a specific portal address or website>

    Example that deploys the web part to a specific portal address:

    .\install-OperationsManager-DashboardViewer.ps1 “C:\Program Files\System Center Operations Manager 2012\” https://localhost:4096

    If an error occurs when you run the script, you must disable the RemoteSigned default code-signing execution policy for the SharePoint 2010 Management Shell. To allow the install-OperationsManager-DashboardViewer.ps1 script to run, type the following command, and then press enter:

    Set-ExecutionPolicy Unrestricted

    You will see some confirmation messages, select Y to confirm, and then run the script.

  4. Verify that the web part is deployed and activated by performing the following steps:

    1. Open the site https://localhost.

    2. In the Site Actions dropdown menu, click Site Settings.

    3. In the Site Collection Administration section, click Site collection features.

    4. Locate Operations Manager Dashboard Web Part.

      • If the button to the right says Activate, then the feature was not automatically activated during deployment. To activate the web part, click the Activate button.

      • If the button to the right says Deactivate, no steps are required. The Operations Manager Dashboard web part can now be inserted into site pages.

  5. If you disabled the RemoteSigned default code-signing execution policy to run the install-OperationsManager-DashboardViewer.ps1 script, you should re-enable it after the script runs. Type the following command and then press enter:

    Set-ExecutionPolicy Restricted

    You will see some confirmation messages, select Y to confirm.

Configuring the Web Part to Connect to a Web Console

After the web part is deployed and activated, you must configure the web part to connect to a web console or environment. You can add more environments at any time. Use the following procedure to configure the environment for a web part, or you can run the script named add-OperationsManager-WebConsole-Environment.ps1, which is in the Operations Manager installation folder under Setup\amd64\SharePoint.

To configure the environment for a web part

  1. On the SharePoint central administration site, in the Site Actions dropdown menu, click View All Site Content.

  2. In Lists, click Operations Manager Web Console Environments.

  3. Click Add new item.

  4. In the Name field, enter a unique name.

  5. In the HostURI field, enter the URI to a server hosting the Operations Manager web console. For example: https://ServerName/OperationsManager/

  6. Click Save.

Adding the Web Part to a Page

After you deploy the Operations Manager web part to a SharePoint site, you can add the web part to pages. When you add the web part, you configure it to display a specific dashboard view. For the configuration, you will need the URI for the dashboard view that you want displayed.

To obtain the URI, open the web console and navigate to the desired dashboard view. The address bar will display an address such as the following:

https://localhost/OperationsManager/#/dashboard%7Btype=Microsoft.SystemCenter.Visualization.Library!Visualization.SlaDashboardViewInstanceDaily%7D

The following procedure creates a SharePoint page with the Operations Manager Dashboard Viewer web part that can only be accessed by users who have an Operations Manager user role, such as Operator or Administrator. To configure the Operations Manager Dashboard Viewer web part so that those who are not Operations Manager users can view it, perform the following steps and then see the procedure How to Configure the Web Part to Use Shared Credentials.

To add the web part to a page

  1. Open an Internet browser, and then navigate to the SharePoint server.

  2. In the Site Actions dropdown menu, click New Page.

  3. Enter a name for the page, and then click Create.

  4. The new page opens with editing tools available. Below Editing Tools, click Insert.

  5. On the Insert toolbar, click Web Part.

  6. In Categories, click Microsoft System Center.

  7. In Web Parts, click Operations Manager Dashboard Viewer Web Part, and then click Add.

  8. Click the arrow in the top right of the web part, and then click Edit web part.

  9. Enter the URI for the dashboard in the Dashboard Parameters field, and then click OK.

  10. On the menu bar, click Page.

  11. Click Save & Close.

Note

After you correctly set up a dashboard web part in SharePoint, you might receive an error message saying “ticket has expired”. This is because there is a very narrow time-out for an override ticket (by default, 5 seconds). If the time on the server running SharePoint and the Web console server differ by more than this value, the connection fails. This is a likely situation if the computers are in different domains and are using a different time source. You can increase the time-out on the SharePoint Server in the web console list, but this would make the server more vulnerable to attack. The best solution is to synchronize the time between the server running SharePoint and the web console server.

Configuring Shared Credentials

To configure the Operations Manager Dashboard Viewer web part so that those who are not Operations Manager users can view it, perform the following procedures. In the first procedure, you configure credentials by creating a Target Application ID in SharePoint. Next, you configure the web part environment.

Note

You cannot configure shared credentials in SharePoint Foundation 2010.

To create a Target Application ID

  1. In SharePoint Central Administration, in the Application Management section, click Manage service applications.

  2. Double-click Secure Store Service.

  3. Click New.

  4. On the Application settings page, enter a Target Application ID, a display name, and an email contact address. The Target Application ID is a unique text string that is used by the Secure Store Service application to identify this target application. The display name is displayed in the user interface. The contact can be any legitimate email address and does not have to be the identity of an administrator of the Secure Store Service application. In Target Application Type, select Group. Click Next.

  5. On the Add Field page, accept the default of Windows User Name and Windows Password, and click Next.

  6. In Target Application Administrators, enter a domain account, and click OK.

  7. Click the dropdown arrow to the right of the name of the Target Application ID that you created, and click Set Credentials.

  8. In the Windows User Name field, enter the user name of the account you want the web part to use. Enter the password for the account and confirm the password, and then click OK.

To configure the web part environment to use shared credentials

  1. On the server hosting the Web console, in the installation folder for the Operations Manager web console, locate the Web.config file. The default installation path is C:\Program Files\System Center Operations Manager 2012\WebConsole.

  2. Open Web.config in a text editor.

  3. Locate the <encryption> section.

  4. Locate the OverrideTicketEncryptionKey entry. In the following example, the first bold value is the encryption algorithm key and the second bold value is the encryption validation algorithm key:

    Example: <key name="OverrideTicketEncryptionKey" algorithm="3DES" value="92799B26F0BF54EE76A40CFECDB29868927D2DA4D7E57EBD"> <validation algorithm="HMACSHA1" value="7526BAC9FC9562835A3872A3DC12CB8B"/>

  5. Copy both keys and close Web.config.

  6. On the SharePoint site, in the Site Actions dropdown menu, click View All Site Content.

  7. In Lists, click Operations Manager Web Console Environments .

  8. Click the web part that you want to configure, and then click Edit Item.

  9. In the TargetApplicationID field, enter the Target Application ID that you created in the previous procedure.

  10. In the Encryption Algorithm Key field, enter the encryption algorithm key that you copied from Web.config.

  11. In the Encryption Validation Algorithm Key field, enter the encryption validation algorithm key that you copied from Web.config.

  12. Click Save.

Repeat this procedure for each Operations Manager environment.

See Also

Concepts

Quick Start Guide for Operations Manager 2012 Beta

-----
For additional resources, see Information and Support for System Center 2012.

Tip: Use this query to find online documentation in the TechNet Library for System Center 2012. For instructions and examples, see Search the System Center 2012 Documentation Library.
-----