USM Group Filter "Dedicated = VirtualMachineHost" does not work

Document ID : KB000130722
Last Modified Date : 10/04/2019
Show Technical Document Details
Issue:
When creating a filter for a USM group filtering for "Dedicated" = "VirtualMachineHost", no results are returned.
Filtering for these servers by name returns the correct result. In the list, "VirtualMachineHost" is shown in the "Dedicated" column.
Environment:
UIM 9.x.x
Cause:
Even though the dedicated field for the ESX host appears in USM as "VirtualMachineHost"
User-added image


In the database the entry is actually "HostSytem"

User-added image

Fro this reason the USM query returns not result. 
Resolution:
For filtering the "dedicated" filter for "VirtualMachineHost" in the USM groups use "HostSystem" instead. 

User-added image