Hosts grayed out in vRanger inventory or Phantom hosts (4047455)

Many times users will upgrade or replace hosts in their environment before removing the host in vRanger.

1. Stop the vRanger Pro Services.
2. Use the following commands to list hosts known to vRanger.

sqlcmd -S localhost\vRangerPro -d vRangerPro -Q "select left(address, 40), IsDeleted from InventorySourceConnection"

3. Execute this command 1 time for each host that needs to be removed from " My Inventory"

sqlcmd -S localhost\vRangerPro -d vRangerPro -Q "update InventorySourceConnection set IsDeleted='True' where address='Hostname' "

4. Restart vRangerPro service.