HP Capacity Advisor 7.2 User Guide

Revising the query
Perhaps you start using ESX in the data center in addition to Hyper-V, and you want to expand
the query to work with either type of virtual machine.
In the revised query, the Type needs to match either VMWARE ESX VMGUEST or MICROSOFT
HYPERV VMGUEST. This corresponds to the Match Any option and requires a new sub-expression
to include both types of virtual machine.
To revise the query, follow these steps:
1. In the first line, click the icon.
The Match drop-down list is displayed.
2. Select Any.
3. Click the icon.
4. Use the drop-down menus to complete the new line:
Type = VMWARE ESX VMGUEST
5. Click the blank area in the Type = MICROSOFT HYPERV VMGUEST line and drag the
expression so that it is just below the Match Any option.
The filter looks like this before the drag-and-drop operation:
After dragging the first row to the sub-expression, the filter looks like this:
6. Click Save to save the revised query.
Example: Reducing licensing costs by finding VMs with one too many cores
Background
The predefined query “VMs with over provisioned vCPUs” checks for virtual machines where the
CPU utilization never goes above 35% utilization. But any VM that matches this query over a long
period of time is probably a good candidate for removing half of its virtual CPUs (vCPUs).
Custom query examples 125