How to Register the Data Warehouse Server in the Lab Environment

  • Article

Applies To: System Center 2012 R2 Service Manager, System Center 2012 SP1 - Service Manager

Use the following procedure to register the newly installed data warehouse server with the lab Service Manager environment.

To register a data warehouse

  1. Log on to the computer that hosts the Service Manager console. Use an account that is a member of the Service Manager and data warehouse management administrators group.

  2. In the Service Manager console, click Administration.

  3. In the Administration pane, expand Administration.

  4. In the Administration view, in the Register with Service Manager’s Data Warehouse area, click Register with Service Manager Data Warehouse.

  5. In the Data Warehouse Registration wizard, on the Before You Begin page, click Next.

  6. On the Data Warehouse page, in the Server name box, type the fully qualified domain name of the computer that is hosting the data warehouse management server, and then click Test Connection. If the test is successful, click Next.

  7. On the Credentials page, you can accept the default entry in the Run as account list, and then click Next, or you can enter credentials from a user or group of your own choosing.

    Important

    The account that you specify will be assigned administrative credentials on the Service Manager management server and granted Read permission on the Service Manager database. You can specify different credentials from other Service Manager management groups when you are registering with the data warehouse.

  8. On the Summary page, click Create.

  9. On the Completion page, when The data warehouse registration succeeded appears, click Close.

  10. A dialog box states that the report deployment process has not finished. In the System Center Service Manager dialog box, click OK.

  11. In a few minutes, after you close the Data Warehouse Registration wizard, the Data Warehouse button appears in the Service Manager console. In the Service Manager console, click the arrow at the lower-right corner of the Service Manager console buttons, and then click Show More Buttons.

You can use a Windows PowerShell command to complete this task. For information about how to use Windows PowerShell to register Service Manager management groups with the data warehouse, see Add-SCDWMgmtGroup (https://go.microsoft.com/fwlink/?LinkId=203096).

To validate the data warehouse registration process

  1. On the computer that is hosting the data warehouse management server, start Windows PowerShell by using administrative credentials.

  2. At the Windows PowerShell command prompt, type the following commands, and then press Enter.

    Set-ExecutionPolicy RemoteSigned
Import-Module .\Microsoft.EnterpriseManagement.Warehouse.Cmdlets.psd1

  3. Type the following command, and then press Enter.

    Get-SCDWMgmtGroup

  4. If registration was successful, a table that contains two rows of data appears. One row displays data for the data warehouse management group, and the other row displays data for the Service Manager management group. If registration fails, only the data for the data warehouse management group appears.

Determine when the deployment is complete

The process of deploying management packs can take up to two hours to finish. You can use the following procedure in Service Manager to determine when the deployment is complete.

To determine when management pack deployment is complete

  1. Start the Service Manager console.

  2. In the Service Manager console, click Data Warehouse.

  3. In the Data Warehouse pane, expand Data Warehouse, and then click Data Warehouse Jobs.

  4. In the Data Warehouse Jobs pane, click MPSyncJob.

  5. In the Tasks pane, under Synchronization, click Details.

  6. In the MP Sync Job dialog box, scroll to the right and examine the Status column.

    Note

    In the MP Sync Job dialog box, click Status to alphabetically sort the Status column.

  7. Scroll through the Status column. The management pack deployment is complete when Associated or Imported is listed in the Status column for all of the management packs. Make sure that no status of Pending Association or Failed appears in the column. In the Data Warehouse Jobs pane, the status of the MPSyncJob has changed from Running to Not Started.

  8. To refresh the MP Sync Job dialog box:

    1. Click OK to close the dialog box.

    2. In the Tasks pane, in the Data Warehouse Jobs area, click Refresh.

    3. In the Data Warehouse Jobs pane, click MPSyncJob.

    4. In the Tasks pane, under Synchronization, click Details.

  9. After the management packs have been deployed (as you determined in step 7), make sure that the following data warehouse jobs appear in the Data Warehouse Jobs pane:

    • Extract_Service Manager management group name

    • Extract_data warehouse management group name

    • Load.Common

    • Transform.Common

    • MPSyncJob

  10. If these data warehouse jobs do not appear, perform the following steps:

    1. In the Data Warehouse Jobs pane, click MPSyncJob.

    2. In the Tasks pane, under Synchronization, click Resume.

    3. Assess whether management pack deployment has finished by returning to step 7 in this procedure.

-----
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.
-----