Reporting

  • Article

Applies To: System Center 2012 - Service Manager, System Center 2012 SP1 - Service Manager

Reports are automatically generated and stored in the data warehouse. Reports are based on OLAP cubes.

Note

Uninstalling the Cloud Services Process Pack does not remove data from the data warehouse. If the Cloud Services Process Pack is uninstalled and then reinstalled, the old data will be displayed along with the new data.

Reporting Prerequisites

Before reports can be generated, the following must occur:

  • Install Data Warehouse

  • Register Data Warehouse with System Center 2012 – Service Manager

  • Install Microsoft Excel 2010

Additional Dependencies

For report data to be correct, these jobs must be completed. If these jobs are not executed, then the reports will be incomplete or outdated.

Make sure that the MPsyncJob occurs first. The MPsyncJob synchronizes management pack data with the data warehouse.

For the reports to be correct, the following three jobs must be executed in this sequence:

  1. Extract_SM-MGMT-GRP

  2. Transform.Common

  3. Load.Common

The Process.CloudServicesCube job must be completed last. If the Process.CloudServicesCube job is not completed, the reports will not be populated with data. By default, the Process.CloudServicesCube job is scheduled to be run every 24 hours.

Sample Reports

There are two types of reports: Tenant and chargeback. Tenant reports contain information about available resources. Chargeback reports contain information on costs. Two sample report files are installed with the Cloud Services Process pack. Each sample report file contains three or four of the following reports:

  • Cloud Resources Report
    The Cloud Resources Report allows the Service Provider and Tenant Administrator to view details of the cloud resources.
  • Tenant Report
    The Tenant Report allows the Service Provider and Tenant Administrator to view the tenant properties.
  • Virtual Machine Report
    The Virtual Machine Report allows the Service Provider, Tenant Administrator and Cloud Resources Users to be able to view the virtual machines along with virtual machine properties.
  • Chargeback Report Per VM
    The Chargeback Report Per VM report allows the Service Provider, Tenant Administrator and Cloud Resources Users to be able to view the chargeback report for the virtual machines that they manage. The chargeback is calculated from the day in which the virtual machine data is synchronized with data warehouse from service manager. Chargeback is not calculated by the date in which the virtual machine was created.
  • Chargeback Report Per Tenant
    The Chargeback Report Per Tenant report allows users to view chargeback costs per tenant.
  • Virtual Machines Daily Specs
    The Virtual Machines Daily Specs report allows users to view properties of virtual machines.
  • VM Cost Settings Daily Report
    The VM Cost Settings Daily Report specifies changes made to cost configurations.