Skip to main content
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.

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

FIM 2010 R2 Test Lab Guide Architecture

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.

ReportExtDemo.zip files

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.

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.