Projector Sample Scenario - Authoring a Report to Display Schema Extensions

Applies To: System Center Service Manager 2010

In this sample scenario, you will import a custom management pack that extends the data warehouse so you can manage projectors in your organization. This will allow you to use a custom projector form to enter information about projectors.

The Directly Authoring a Management Pack File to Manage Projectors topic describes how to create the custom Servicemanager.projector.mp management pack, which is referred to in this scenario.

The projector sample scenario includes the following steps:

  • Step 1: Import the management packs that define the new projector configuration item class.

  • Step 2: Populate the database with information about the projectors that you want to manage.

  • Step 3: Create the List of Projectors report, which displays all the projector configuration items that you have previously created.

  • Step 4: View the List of Projectors report in the Service Manager console.

Step1: To import the management packs that define the new projector configuration item class

  1. Copy the following files:

    • ServiceManager.Projector.mp

    • Datawarehouse.Projector.mp

    • New_CI_lab.dll Datawarehouse.Projector.mp

    And then, paste the files in your Service Manager installation folder.

    For example, paste the files to the following location: C:\Program Files\Microsoft System Center\Service Manager 2010.

  2. Follow these steps to import the ServiceManager.Projector.mp file:

    1. In the Service Manager console, click Administration.

    2. In the Administration pane, click Management Packs.

    3. In the Tools pane, double-click Import Management Pack.

    4. In the Select Management Pack to Import dialog box, select the MP files(*.mp) file type option, select the Servicemanager.projector.mp file, and then click Open.

    5. In the Import Management Packs dialog box, click Import.

    6. Wait for the import success message, and then click OK.

  3. Import the Datawarehouse.Projector.mp file by following the same steps.

    Note

    Depending on your configuration, the import of a management pack might take half an hour.

Step2: To create configuration items in the database for the projectors that you want to manage

  1. Close and then reopen the Service Manager console.

  2. In the Service Manager console, click Configuration Items.

  3. In the Configuration Items pane, expand Projectors, and then select All Projectors.

  4. In the Tasks pane, click Create Projector.

  5. Enter information about a projector in the projector form, and then click Submit and Close.

    Note

    In the Serial Number field, make sure that you enter only numbers; otherwise, the submission fails.

  6. Repeat this procedure for several projectors.

Step3: To create the List of Projectors report

  1. After you import the management packs in the previous procedures, ensure that the dimension has deployed successfully. To do this, run the following SQL query on the data warehouse management server, and verify that the query runs without any error.

    SELECT * FROM DWDataMart.dbo.ProjectorDim
    
  2. On the data warehouse management server, start SQL Server Business Intelligence Development Studio. To do this, click Start, click Programs, point to Microsoft SQL Server 2008, and then click SQL Server Business Intelligence Development Studio.

  3. In SQL Server Business Intelligence Development Studio, click File, point to New, and then click Project.

  4. In the New Project dialog box, select Report Server Project Wizard in the Visual Studio installed templates list, and then click OK.

  5. Complete the Report Wizard as follows:

    1. On the Welcome page, click Next.

    2. On the Select the Data Source page, click Edit.

    3. In the Connection Properties dialog box, select the data warehouse in the Server Name box, and select the SCDM database in the Select or enter a database name box.

    4. Select Test Connection, and then click OK in the Test results dialog box.

    5. In the Connection Properties dialog box, click OK.

    6. On the Select the Data Source page in the Report Wizard, select Make this a shared data source, and then click Next.

  6. On the Design the Query page, click Query Builder.

  7. On the Query Designer page, click the Add Table icon.

  8. In the Add Table dialog box, select the ProjectorDim, ProjectorOwnedByUserFact, and the UserDim tables, click Add, and then click Close.

  9. Drag the ProjectorOwner_UserDimKey field from the ProjectorOwnedByUserFact table into the UserDimKey field in the UserDim table.

  10. In the ProjectorDim table, select the following fields: Make, Model, SerialNumber, Location and Condition.

    In the UserDim table, select the Email field.

    All selected fields should now display in the Grid pane.

  11. In the Query Designer click OK.

  12. In the Report Wizard, click Next.

  13. On the Select the Report Type page, select Tabular, and then click Next.

  14. On the Design the Table page, select all the fields that are listed under Available fields. To do this, press the CTRL and select each field.

  15. Click Details, and then click Next.

  16. On the Choose the Table Style page, select a color, and then click Next.

  17. On the Choose the Deployment Location page, leave the default Report server value. In the Deployment folder box, type Microsoft.SystemCenter.Reporting.Folder.ServiceManager/ServiceManager.Console.Reporting.ConfigurationManagement, and then click Next.

  18. On the Completing the Wizard page, type List of Projectors in the Report name box, and then click Finish.

  19. Click Build, and then click Deploy Report <report name>.

Step4: To view the List of Projectors report in the Service Manager console

  1. On the Service Manager management server, open the Service Manager console.

  2. In the Service Manager console, click Reporting.

  3. In the Reporting pane, click Configuration Management.

  4. In the Configuration Management pane, select the List of Projectors report.

  5. In the Tasks pane, click the Execute Report task.

  6. View the report.

Did you find this information helpful? Please send your suggestions and comments about System Center Service Manager documentation to scsmdocs@microsoft.com.