Topic Last Updated—August 2008
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
 Note |
|---|
| 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. |
|
|
John confirms that his site meets the prerequisites for using SQL Reporting Services. |
|
|
He then reviews important planning information for using SQL Reporting Services in Configuration Manager 2007 R2. |
|
|
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. |