Manually Remove the VMs (in disconnected state) from Inventory when the Host is Unavailable

1.    Remove the host from the cluster.

2.    Removing the host would also remove the vms living on that host from inventory.

3.    Next, browse the datastores for each vm that was on the host, right click the vmx file, and select add to inventory.