Introduction to Reporting in Configuration Manager 2012

Updated: March 15, 2011

Applies To: System Center Configuration Manager 2012

The Microsoft System Center Configuration Manager 2012 reporting feature provides a set of tools and resources that help you use the advanced reporting capabilities of SQL Server Reporting Services and the rich authoring experience that Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 provides.

What’s New in Configuration Manager 2012

The following reporting features are new or have changed in Configuration Manager 2012.

 

Feature Description

The reporting point no longer used

The Reporting Services point is the only site system role used for reporting in Configuration Manager 2012.

Full integration of the Configuration Manager 2007 R2 SQL Server Reporting Services solution

In addition to standard report management, Configuration Manager 2007 R2 introduced support for SQL Server Reporting Services reporting. Configuration Manager 2012 has integrated this solution and added functionality. Advantages of integrating SQL Server Reporting Services include the following:

  • Uses an industry standard reporting system to query the Configuration Manager 2012 database.

  • SQL Reporting Services high performance, availability and scalability.

  • Enables users to subscribe to reports; for example, a manager could automatically be e-mailed a report each day, detailing the status of a software update rollout.

  • Enables users to export reports in a variety of popular formats.

When you install the Reporting Services point in Configuration Manager 2012, the built-in Configuration Manager reports are automatically copied to the Reporting Services server and organized in folders by report category.

Report Builder 2.0 integration

Configuration Manager 2012 uses Microsoft SQL Server 2008 Reporting Services Report Builder 2.0 as the exclusive authoring and editing tool for both Model and SQL-based reports. Report Builder 2.0 is automatically installed when you create or modify a report for the first time. Report Builder 2.0 supports the full capabilities of SQL Server 2008 Reporting Services including the following:

  • Delivers an intuitive, report authoring environment with a look and feel similar to Microsoft Office.

  • Flexible report layout capabilities of SQL Server 2008 Report Definition Language.

  • Data Visualizations including charts and gauges.

  • Richly formatted textboxes.

  • Ability to export to Microsoft Word format.

Subscription management

Report subscriptions in SQL Reporting Services enable you to configure the automatic delivery of specified reports by e-mail or to a file share at scheduled intervals.

Reporting experience

You can run Configuration Manager 2012 reports in the Configuration Manager console by using Report Viewer or you can run reports from a browser by using Report Manager. Each method for running reports provides a similar experience.

Localized reporting

Reports in Configuration Manager 2012 are rendered in the locale of the installed Configuration Manager console. In the SQL Reporting Services Report Manager, you can browse and change the locale settings. Subscriptions are rendered in the locale that SQL Server Reporting Services is installed. When you are authoring a report, you can specify the assembly and expression.

See Also