Export (0) Print
Expand All

Example Scenario for Implementing SQL Reporting Services

Applies To: System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3

This scenario provides an example of how SQL Reporting Services in Configuration Manager 2007 R2 can be implemented and configured to solve the following business requirements:

  • Use an industry-standard reporting system to query the Configuration Manager 2007 database.

  • Enable users who are not familiar with Configuration Manager 2007 reporting to generate ad hoc reports.

  • Allow users to subscribe to reports.

  • Simplify the creation of reports in Configuration Manager 2007 R2

noteNote
The information in this topic applies only to Configuration Manager 2007 R2 and Configuration Manager 2007 R3.

Implementing and configuring SQL Reporting Services integration in Configuration Manager 2007 R2

Woodgrove Bank has deployed Configuration Manager 2007 R2 to manage and report on the status of computers on the network. John Woods is Woodgrove Bank's IT systems manager. He learns that Configuration Manager 2007 R2 SQL Reporting Services will allow him to accomplish the stated business requirements. He decides to follow this course of action:

 

Process Reference

John reviews the Microsoft SQL Server Reporting Services Web site and the overview of SQL Reporting Services integration with Configuration Manager 2007 R2 in the Configuration Manager 2007 documentation library.

John reviews the process for installing, configuring, and using SQL Reporting Services in Configuration Manager 2007 R2.

Administrator Checklist for SQL Reporting Services

John confirms that his site meets the prerequisites for using SQL Reporting Services.

Prerequisites for SQL Reporting Services

He then reviews important planning information for using SQL Reporting Services in Configuration Manager 2007 R2.

Planning for SQL Reporting Services

John then installs and configures the SQL Reporting Services component of SQL Server 2005.

How to Configure Microsoft SQL Server for SQL Reporting Services

In the Configuration Manager console, John creates and configures a reporting services point and configures a folder in which to store reports. He then sets this as the default reporting point for the site.

John copies all existing Configuration Manager 2007 reports into SQL Reporting Services.

How to Copy Configuration Manager Reports to SQL Reporting Services

John’s manager requires some reports that are not included as standard reports with Configuration Manager 2007 R2. He creates a number of new reports using the SQL Reporting Services wizards.

How to View SQL Reporting Services Reports from the Configuration Manager Console

John’s manager would like certain reports sent to him by e-mail on a daily basis. To accomplish this, John sets up report subscriptions for selected reports.

See Also

For additional information, see Configuration Manager 2007 Information and Support.
To contact the documentation team, email SMSdocs@microsoft.com.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft