SCRM 2006 Software Development Kit

Microsoft System Center Reporting Manager (SCRM) 2006 is a reporting tool that consolidates event and performance information from Microsoft Operations Manager (MOM) 2005 and change and configuration management information from Microsoft Systems Management Server (SMS) 2003 and combines this information with business context data from sources such as Active Directory Domain Services. SCRM 2006 uses Microsoft SQL Server 2005 Reporting Services as the foundation of its reporting capabilities.

The SCRM Software Development Kit provides the necessary documentation for customizing existing SCRM 2006 reports. SCRM 2006 reports are customized using Microsoft SQL Server 2005 Business Intelligence Studio and make extensive use of SQL stored procedures and SQL views in the SCRM 2006 presentation database.

To develop SCRM 2006 reports, knowledge of the following technologies is required:

  • SQL Server stored procedures and views
  • SQL Server Reporting Services
  • SMS 2003
  • MOM 2005

The following sections of the SCRM 2006 Software Development Kit describe how to customize reports and provide a complete reference of SCRM 2006 presentation database views and stored procedures:

  • SCRM 2006 Report Customization   This section provides an overview of SCRM 2006 report customization and provides procedural steps for common report customization tasks.
  • SCRM 2006 Stored Procedures   This section provides the customized sample stored procedures used by the report customization tasks.
  • SCRM 2006 Stored Procedures   This section provides a complete reference of the SCRM 2006 stored procedures that can be used in report customization.
  • SCRM 2006 SQL Views   This section provides a complete reference of the MOM and SMS views that can be used in report customization.

Other Resources