Test Lab Guide: Demonstrating Forefront Identity Manager 2010 R2 Reporting Extensibility

In This Guide

This guide contains instructions for demonstrating Forefront Identity Manager 2010 R2 Reporting Extensibility using the Reporting Extensibility demo files can be found here. These files are contained in a folder called ReportingExt that is contained in the zip file.

A full copy of this document is available for offline viewing here.

Important

The following instructions are for demonstrating the Forefront Identity Manager 2010 R2 Reporting Extensibility test lab using a scaled-out deployment. That is, the FIM Portal and the FIM database will not be residing on the same server. The SCSM Management Server and the Data Warehouse will be on separate servers. Individual computers are needed to separate the services provided on the network and to clearly show the desired functionality. This configuration is neither designed to reflect best practices nor does it reflect a desired or recommended configuration for a production network. The configuration, including IP addresses and all other configuration parameters, is designed only to work on a separate test lab network. Attempting to adapt this Forefront Identity Manager 2010 R2 test lab configuration to a pilot or production deployment can result in configuration or functionality issues. To ensure proper configuration and operation for your pilot or production Forefront Identity Manager 2010 R2 deployment, use the additional documentation provide with the Forefront Identity Manager 2010 R2.

Test Lab Overview

In this test lab, no additional servers are required other than the ones need for the preceding steps

The Forefront Identity Manager test lab uses the following subnet:

• The intranet established by the Base Configuration Test Lab Guide, referred to as the Corpnet subnet (10.0.0.0/24).

Computers on each subnet connect using a hub or switch. See the following figure.

This test lab will guide you through the Forefront Identity Manager 2010 R2 Reporting Extensibility process. The purpose of this test lab is to allow for the creation of a basic test lab environment that consists of Forefront Identity Manager 2010 R2 Reporting and demonstrates reporting extensibility. This is done by adding two new attributes, Entitlements, and Tier, to the Group object with FIM. Then we will synchronize these new attributes to the SCSM Datawarehouse and display it in a report.

Hardware and Software Requirements

The files contained in the ReportExt.zip file that can be downloaded from the Microsoft Download center here.

About the ReportingExt files

The ReportingExt folder contains several files and folders that are used in this demonstration of Forefront Identity Manager 2010 R2 Reporting Extensibility. The following table will provide an explanation of these files and folders. The location is the required location for the files. This is outlined in step 7.

Name	Location	Description
Microsoft.Forefront.IdentityManager.Datawarehouse.Test.Extensibility.xml	C:\ReportingExt\binding	The purpose of this file is to define the object mapping between the SC Data Warehouse and FIM.
Configuration.xml	C:\ReportingExt\rcdc	The RCDC configuration file that adds the ability to edit the values for the Entitlements and Tier attributes.
GroupExtensionTestReport.rdl	C:\ReportingExt\report	This is the SQL Reporting report that defines columns, filters and generally how the report will look.
Microsoft.FIM_Report_Group_SP_GetExtensionTest.Report.Install.sql	C:\ReportingExt\report	This is the script that specifies how to install the SQL Stored Procedure (SPROC) which retrieves report data from the Data Warehouse. It also defines how to retrieve that data.
Microsoft.FIM_Report_Group_SP_GetExtensionTest.Report.Uninstall.sql	C:\ReportingExt\report	This is the script that specifies how to uninstall the SQL Stored Procedure (SPROC).
Microsoft.FIMGroupExtensionTest.Report.Library.xml	C:\ReportingExt\report	This xml file contains references to the RDL, the install, and the uninstall scripts and defines where the report appears in SQL Services Reporting Studio and the SCSM console.
Microsoft.Forefront.IdentityManager.Datawarehouse.Test.Extensibility.xml	C:\ReportingExt\schema	Defines where in the SCDW schema objects defined in the management pack will live. Also defines any new schema that is required to store new object or attribute types.
Changes.xml	C:\ReportingExt	The changes to the FIM Schema.
FIMReportDefinitioncommand.txt	C:\ReportingExt	The command line syntax to run Import-FIMReportDefinition in PowerShell.
FIMReportingSchemaDefinitioncommand.txt	C:\ReportingExt	The command line syntax to run Import-FIMReportingSchemaDefinition in PowerShell.
Import-testschema.ps1	C:\ReportingExt	The PowerShell script used to import the FIM schema changes.
TestFimReportingKeyPair.snk	C:\ReportingExt	Public and Private key used for optionally sealing the management packs before importing them into SCSM.
TestFIMReportingPublicKey.snk	C:\ReportingExt	Public key used for optionally sealing the manamgement packs before importing them into SCSM.

Steps for Configuring the Forefront Identity Manager 2010 R2 Test Lab

There are nine steps to follow when setting up the Forefront Identity Manager 2010 R2 test lab based on the Forefront Identity Manager 2010 R2 Test Lab Guide.

• Step 1: Set Up the Base Configuration Test Lab—The Base Configuration is the core of all Test Lab Guide scenarios. The first step is to complete the Base Configuration.

• Step 2: Set Up the Exchange Server 2010 with Service Pack 1 Test Lab—The second step is to complete the Exchange Server 2010 with Service Pack 1 test lab guide. This provides Active Directory® attributes and e-mail functionality for the FIM Service account.

• Step 3: Set Up the SQL Server 2008 R2 Enterprise Test Lab—The third step is to complete the SQL Server 2008 Enterprise with Service Pack 2 test lab guide. This provides the database server for your FIM installation.

• Step 4: Set Up the System Center Service Manager SP1 Test Lab

• Step 5: Set Up the Forefront Identity Manager 2010 R2 Test Lab—The fifth step includes installing Forefront Identity Manager 2010 R2.

• Step 6: Set Up the Demonstrating Forefront Identity Manager 2010 R2 Reporting Test Lab—The sixth step goes through setting up and configuring out-of-box reporting.

• Step 7: Configure Forefront Identity Manager 2010 R2 Reporting Extensibility—The seventh step goes through extending the FIM schema, extending the Datawarehouse schema, binding the schema extensions, and importing these xml files, a sql stored procedure and a new report.

• Step 8: Verify the Extensibility— In the final step we verify the new objects and attributes that were added to the Datawarehouse.

This guide provides steps for configuring the computers of the Forefront Identity Manager 2010 R2 Reporting Extensibility test lab. The following sections provide details about how to perform these tasks.