Cannot remove the orphaned/non-existing ESX hosts from the Virtualization Assets

9/19/2019 8:58 PM

12/28/2022 8:21 PM

This is an article on how to remove or resolve the issue of an orphaned/deleted hosts displaying in the Virtualization page or assets
First Verify if they are ESX that have been decommissioned OR if are they still managed by a VCenter that VMAN is monitoring and they were just placed in a disconnected state.  

Disconnecting a managed host does not remove it from vCenter Server it will only temporarily suspends all monitoring activities that vCenter Server performs. It will appear with a grey status in Orion.
If this is the case and we manually delete them in the VIM_Hosts table in the db, VMAN will rediscover them when it polls the VC where those host are still in and put them back.

Virtualization Manager

vCenter is still managing the ESXi host.
 

If the VCenter is added in VMAN, It will auto-discovered all managed ESX.
Even if the node entry is deleted as long as the ESX is still managed by the VCenter it will appear in the VMAN summary.

To remove the host you can either:

• Modify the service account used to add the VC to not have access to the specific ESX host

OR 

• Remove the ESX in vsphere.

If it still displayed even the conditions above are checked or done. Use the following steps below on the Orion Server:

1. Go to the Database Manager then query VIM_Host
2. Enable table editing and then delete the row of the target hosts.
3. Check the Virtualization Summary if the hosts are still present

If you would like to delete both hosts underneath a VCenter AND the VCenter you will need to also do the following steps:

1. Check the tables: vim_hosts, vim_vcenter, vim_datacenter
2. Use VCenterID from vim_vcenter table to find all of the DataCenterIDs from the vim_datacenter table.
3. Use the DataCenterIDs to get HostIDs from vim_hosts table
4. Manually remove those hosts with those IDs from vim_hosts table
5. Manually remove the datacenters with the VCenterID
6. Manually remove the VCenter

For more details on this process please call into the SW support line or open a ticket through your customer portal.