Reporting
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:
Extract_SM-MGMT-GRP
Transform.Common
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.