Available Reports

Overview

This document lists all the standard reports currently available in Capacity Planner along with their description and examples. Each report includes parameters to add flexibility. These allow you to select and filter data of interest and to choose output formats. For more details see, Report Parameters.

If you require a custom report to be added to your project, please contact your Capacity Planner representative.

Highly inactive VMs

This report identifies virtual machines across the selected baseline model that are considered highly inactive (have very low levels of CPU utilization). Peak, 99th percentile, 95th percentile and mean values are given for each VM and by default the reports are ordered by peak CPU utilisation (from smallest to largest). A summary of the disk space used by each VM is also provided.

This report allows you to very quickly identify the VMs that can be switched off or ones that spend significant amount of time inactive, with very small times of peak activity.

Example

In the image below, you can see an example of an output of this report.

The default sorting can be changed by clicking the arrows above each column to sort by that column.

Cluster events

This report displays all current projected cluster capacity events and the time series for these events. It also provides information on how often this cluster event has been raised and at which severity. You can view the history of each event using the Drill through to Event History option which takes you to the Cluster event history report.

Example

In the image below, you can see an example of an output of this report.

This example shows increasing CPU over time. If this trend continues, the cluster will soon have less than one redundant server available.

Cluster event history

This report shows the event history for each cluster:

  • Blue indicator marks the expected saturation date when the event was first raised.
  • Red indicator marks the most recently calculated saturation date.
  • A series of indicators show each date between the first and the most recent saturation date.

This can be used to gain an understanding of whether an event is coming closer and more imminent, or moving further into the future as a result of a flattening trend.

A chart is also provided showing the time series of allocated vCPUs in the cluster, giving an indication of growth that may also contribute to changes in the cluster saturation dates.

Example

In the image below, you can see an example of an output of this report.

This example shows a cluster event that has been raised a number of times. When first raised, the projected saturation date was 29 October 2018. The most recent saturation date predicted is now 18 September as indicated by the red indicator on the chart.

The lower chart shows a time series trend of allocated vCPUs in this cluster. There has been a rise over the course of the last 3 months which is most likely leading to the change in projected saturation date for the cluster.

Metric analysis — multi-chart

This report allows you to create box plots, bar charts, line charts, and radar charts as well as linear trend charts and scatter plots with linear regression calculations. The report can be run using single or multiple metrics on groups of entities at any aggregation level available within Capacity Planner.

If you want to display all entities on the same chart, use the Metric analysis — single-chart report.

An additional feature allows you to enter your own RAG (Red, Amber, Green) threshold values and display and sort by them. If no threshold operators are selected, the RAG status column is hidden and RAG threshold lines and status column do not appear on the report.

The Linear Trend and Scatter Plots calculate linear regression lines and associated intercept, gradient, and R2 values. Reports can be filtered and ordered by R2 values to allow the most significant ones to be identified. In these reports red and amber threshold values are used to calculate values on the best fit line allowing projected dates and values to be displayed. For example, in the Linear Trend report, the report display shows the projected dates at which amber and red threshold values would be reached.

Available chart types are:

  • Box plot — this chart can be used for daily summaries and above (day, week, month etc.). It shows percentile values as a box with whiskers above and below to indicate the range of value distribution. This is the only chart type that can show more than one percentile value. However, the Percentile/Value selector still controls the metric used for RAG thresholds.
  • Bar chart — values are shown as vertical bars.
  • Line chart — values are plotted as points on a line.
  • Linear trend — this chart plots metric values and linear regression line for any given metric. This chart should be used with hourly average or unaggregated data for shorter term trends. Longer term trends can make use of daily summary values.
  • Radar chart — this chart plots all entities on a single radar visualization. This chart works well for comparing metrics but we recommend to use it with a relatively small number of entities to improve readability.
  • Scatter plot (metric pairs) and scatter plot (metric pairs reversed) — these chart types appear in the drop-down list if two metrics are selected. They calculate linear regression lines based on metric pair values. Switching between these two report types reverses the X and Y axes of the report. Red and Amber threshold values calculate X axis values from the given Y axis values based on the regression line.
  • Stacked bar chart — this chart presents a single bar per date showing the relative metric values.

Example

In the image below, you can see an example of an output of this report.

It shows CPU and memory daily box plots with the red RAG threshold set to 80% and amber threshold set to 70%. The report is ordered by RAG status.

Metric analysis — single-chart

This report allows you to create bar charts, box plots, line charts, and treemaps with one or more entities shown on the same chart. Plotting multiple entities on the same chart can enable easier side by side comparisons.

If you want to display each entity on a separate chart, use the Metric analysis — multi-chart report.

Available chart types are:

  • Bar chart — values are represented as horizontal bars. The entity names, dates, and values can be sorted on the chart using the sort indicator .
  • Box plot — this chart can be used for daily summaries and above (day, week, month etc.). It shows percentile values as a box with whiskers above and below to indicate the range of value distribution. This is the only chart type that can show more than one percentile value. However, the Percentile/Value selector still controls the metric used for RAG thresholds.
  • Line chart — values are plotted as points on a line.
  • Treemap — entities are shown as areas in a rectangle, with size of area representing the value.

Example

In the images below, you can see examples of line charts, box plots and bar charts and for this report.

Line chart report:

Box plots report:

Bar charts report:

Metric threshold analysis

This report allows you to select a statistical measure for any metric and use it in combination with a threshold. The measure is an indication of how much total time in the chosen baseline period that metric has been above the specified threshold. You can select up to 3 metrics for threshold breach checks.

The report is presented in a visual tabular format of horizontal bar charts. A bar is shown as red if a threshold was crossed.

You can drill through the measures and investigate the time series data for the entity/metric combination. To do this, click the bar for the selected entity.

Example

In the image below, you can see an example of an output of this report.

It shows peak CPU, memory and CPU ready% per VCPU over an entire baseline period.

Metric threshold percentiles

This report shows all statistical values for selected entities for a given metric. Statistical values available are: minimum, 5th percentile, 25th percentile, 50th percentile (median), mean, 75th percentile, 95th percentile, 99th percentile, maximum and latest value.

A threshold filter is available to view only those entities that have breached a user-defined threshold. To use this feature, select values for Filter Operator and Filter Threshold. This is particularly useful for identifying very busy or inactive servers. A box plot view is also available by selecting the Chart display type.

You can drill down to further plots and time series for any entity in the table or chart. To do this, click the entity name on the table or the box plot in the chart.

Example

In the image below, you can see an example of an output of this report.

It shows all VMs where the 95th percentile of CPU is greater than a specified value. In this case, using 0 shows all measures for this metric for all machines.

Scatter plot

This report allows you to generate a scatter plot showing metric pairs values from any two entities.

Example

In the image below, you can see an example of an output of this report.

Time above threshold

This report allows you to select a baseline, group of entities, and a metric, and determine the total time spent above a given threshold for each entity. You can also identify the single longest time period for which it was above that threshold. You can filter results further by days of the week and time of day.

You can drill through the length of longest episode for a detailed time series of when that episode occurred.

Example

In the image below, you can see an example of an output of this report.

VM storage summary

This report displays the comparison between storage allocated to a virtual machine and storage used by the virtual machine OS drives. It can be used to identify potential storage waste in an environment. The report is ordered by most wasteful VMs. When the report is generated, you can expand on drive details for more information on the VM drives and utilisation compared to allocated thick storage.

When filtering data that should be displayed in the report, you can specify the VM state, Current or Removed. Current VMs are the ones that are still actively generating data.

For investigative or exploratory work, we recommend using the Current state for reporting.

Example

In the image below, you can see an example of an output of this report.

Other reports

Except for these advanced reports, you can also create Service, Infrastructure, and Scenario reports directly from a Baseline View or Forward Thinking scenario model.

For more information see, Infrastructure and Service Reports and Scenario Reports.