Help Center
Choose product document...
Veeam Management Pack 8.0 Update 5 for System Center
Veeam MP Resource Kit Guide

Usage Example

Now, you can create your own sample pivot table for vSphere hosts in the environment to show all average performance metric values that have been recorded to the Ops Mgr DW during the previous 7 days:

  1. In the PowerPivot for Excel window, switch to the Home tab and select PivotTable > PivotTable.
  2. In the Insert Pivot window, select New Worksheet. This will open a new worksheet in Excel.

Insert a pivot

  1. In PivotTable Fields, expand the Entities drop-down list, right-click ManagedEntityTypeDefaultName and select Add to Report Filter. This will add a new filter for monitored objects in the worksheet.

Add a new filter

  1. Expand the drop-down list in the cell with the All value and select VMware vSphere Host. This will narrow the filter results to the objects of the VMware vSphere Host class.

Select VMware vSphere Host class

  1. In PivotTable Fields, expand the Perf drop-down list, right-click CounterName and select Add to Column Labels. This will add new columns with performance metric names in the worksheet.

Similarly, righ-click AverageValue, and select Add to Values. This will display metric values for each column in the worksheet.

Add new columns

  1. In the VALUES field, expand the Sum of AverageValue drop-down list and select Value Field Settings.

In the Value Field Settings window, select Average from the Summarize value field by list.

Specify field settings

  1. In PivotTable Fields, expand the Entities drop-down list, right-click DisplayName and select Add to Row Labels. This will display a list of hosts in the worksheet.

Add new rows

You can use conditional formatting and highlight hosts with the highest CPU usage level:

  1. Select values in the cpuUsageMHz column.
  2. On the Home tab, click Conditional Formatting > Color Scales > Red – Yellow- Green Color Scale.

Use conditional formatting

You can also add a timeline to narrow the time frame for data analysis:

  1. Open the Pivot Tools Analyze tab and click Insert Timeline.
  2. In the Insert Timeline window, select Perf.DateTime and click OK.

Insert a timeline

In the DateTime window, adjust timeline to show DAYS. Then stretch the timeline to include the exact dates for which you want the data to be analyzed.

Adjust date and time interval

Veeam Large Logo

Veeam MP for VMware User Guides

Veeam MP for VMware Reference

Veeam MP for VMware Online Knowledge Base

Veeam MP for Microsoft Hyper-V User Guide

Veeam MP for Hyper-V Reference

MP for Veeam Backup & Replication User Guide

MP for Veeam Backup & Replication Reference

Veeam Capacity Planning for Hybrid Clouds User Guide

Veeam MP Report Knowledge

Veeam MP VEShell Reference

Veeam MP Resource Kit Guide