Virtual machine hosts missing in the Virtualization Assets resource

This occurs when the ESX host is not in the VIM_Hosts table even if the node is set up as a VMWare server. 

1. Run the following SQL statement to reset the node:

   -- Scripts are not supported under any SolarWinds support program or service. 
   -- Scripts are provided AS IS without warranty of any kind. SolarWinds further 
   -- disclaims all warranties including, without limitation, any implied warranties 
   -- of merchantability or of fitness for a particular purpose. The risk arising 
   -- out of the use or performance of the scripts and documentation stays with you. 
   -- In no event shall SolarWinds or anyone else involved in the creation, 
   -- production, or delivery of the scripts be liable for any damages whatsoever 
   -- (including, without limitation, damages for loss of business profits, business 
   -- interruption, loss of business information, or other pecuniary loss) arising 
   -- out of the use of or inability to use the scripts or documentation.
   
   UPDATE Nodes SET EntityType = 'Orion.Nodes' 
   WHERE NodeID='[NodieID]'

2. Edit the node and select Poll for VMWare.