You can create a report for virtual machine hosts that have problematic health status.

Prerequisites
■

Verify that you are connected to a vRealize Operations Manager instance.

■

Verify that you are connected to the vCenter Server system that is monitored by the vRealize Operations Manager instance.

Procedure
1

Get all problematic host resources in vRealize Operations Manager that have red or yellow health status. 

$hosts = Get-OMResource | where { $_.ResourceKind -eq 'HostSystem' -and $_.Health -in ('Red', 'Yellow') }
2

Get the virtual machine hosts that cause the problem. 

$hosts | Get-VmHost