Register with the Service Manager data warehouse to enable reporting

Applies To: System Center 2016 - Service Manager

After you have deployed the Service Manager management servers and data warehouse management servers, for reporting to function you must run the Data Warehouse Registration Wizard. This wizard registers the Service Manager management group with the data warehouse management group. It also deploys management packs from the Service Manager management server to the data warehouse management server.

The management pack deployment process can take several hours to complete. It is a best practice not to turn off any Service Manager computers or stop any Service Manager services during this time. During this registration process, you can continue to use the Service Manager console to perform any Service Manager functions that you want.

To ensure that reporting data will be available, use the procedures in the following topics to register the data warehouse and deploy the management packs.

Run the Data Warehouse Registration wizard

You can use the following steps in System Center - Service Manager to use the Data Warehouse Registration Wizard to register with the Service Manager data warehouse.

To run the Data Warehouse Registration wizard

  1. By using an account that is a member of the Service Manager and data warehouse management administrators group, log on to the computer that hosts the Service Manager console.

  2. In the Service Manager console, select 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 (FQDN) of the computer 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 it will be 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 is not finished. This is to be expected. On 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 will be added to 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.

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

Determine when Data Warehouse registration is complete

Several management packs are imported during the data warehouse registration process in Service Manager. Data warehouse registration is complete when all of the management packs have been imported. You will have to determine when that process is complete by using the following procedure.

To determine when management pack deployment has completed

  1. Start the Service Manager console.

  2. In the Service Manager console, select 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 MPSyncJob details pane, in the Synchronization Job Details list, scroll to the right to view the Status column, and then click Status to alphabetically sort the status column.

  6. Scroll through the Status list. The management pack deployment process is complete when the status for all of the management packs is Associated or Imported. Make sure that there is no status of either Pending Association or Failed in the status list. In the Data Warehouse Jobs pane, the status of the MPSyncJob will have changed from Running to Not Started when the registration process is complete. This deployment process can take up to two hours to complete.

  7. Use the following steps to periodically refresh the Data Warehouse Job pane to monitor the progress of the registration process:

    1. In the Tasks pane, under Data Warehouse Jobs, click Refresh.

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

    3. In the MPSyncJob details pane, in the Synchronization Job Details list, scroll to the right to view the Status column, and then click Status to alphabetically sort the status column.

  8. After the management packs have been deployed (as determined in step 6), make sure that the following five 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

    Note

    If these five data warehouse jobs do not appear, complete the following steps:

    1. In the Data Warehouse Jobs pane, click MPSyncJob.
      1. In the Tasks pane, under Synchronization, click Resume.
      2. Determine whether management pack deployment is complete by repeating steps 4through 6.

Next steps