Power management in Configuration Manager 2007 R3 uses Microsoft SQL Server Reporting Services to display reports about its operations. SQL Server Reporting Services integration was introduced in Configuration Manager 2007 R2. You must configure it before you can import and run the reports for power management. For more information about how to install and configure SQL Server Reporting Services, see SQL Reporting Services in Configuration Manager 2007 R2 and Later.

Use the following procedure to import the Configuration Manager 2007 R3 power management reports into SQL Server Reporting Services.

Note
The information in this topic applies only to Configuration Manager 2007 R3.

To import power management reports into SQL Server Reporting Services

  1. In the Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services, and then expand the node.

  2. Right-click the server running Microsoft SQL Server Reporting Services to which the power management reports will be copied, and then click Copy Reports to Reporting Services.

  3. On the Data Source Settings page of the Copy Reports Wizard, ensure that the Configuration Manager 2007 database server name and database name are correct. For more information about the options on this page, see Report Server Properties: Data Source Settings Tab.

  4. Click Next.

  5. On the Data Source Authentication page of the Copy Reports Wizard, choose the authentication method that is required to run the copied power management reports on the server running SQL Server Reporting Services. For more information about the options on this page, see Report Server Properties: Data Source Authentication Tab.

  6. Click Next.

  7. On the Select Reports page of the Copy Reports Wizard, select Import Report Definition Language files from a Microsoft signed cabinet file.

  8. Click Browse.

  9. In the Browse for Folder dialog box, navigate to the folder <InstallationPath> \ Reports \ Power Management, select MicrosoftReportPack.cab, and then click Open.

    Important
    You can only import report CAB files that are supported by Microsoft into SQL Server Reporting Services in the Configuration Manager console.

  10. On the Select Reports page of the Copy Reports Wizard, select All Reports.

  11. Click Next.

  12. On the Security page of the Copy Reports Wizard, specify which users can access the copied reports and to which roles they must belong. For more information about the options on this page, see Reporting Services Properties: Security Tab.

  13. Click Next.

  14. On the Summary page of the Copy Reports Wizard, review the actions that will be taken, and then click Next.

  15. After the reports are copied, click Next.

  16. On the Confirmation page of the Copy Reports Wizard, review the displayed information, and then click Close to exit the wizard.

    Note
    If a report fails to import, double-click the entry to open the Details dialog box, which lists details of the error in importing the report. The description field only displays the first 512 characters of each message. Descriptions longer than 512 characters are truncated.

See Also