Delete ESX Ghost Entry

10/22/2018 6:32 PM

7/9/2020 11:26 PM

This article provides information on how to delete the ESX Ghost Entry from the SolarWinds Database.

Network Performance Monitor

Using Database Manager

1. On your Windows Server, search for Database Manager and then click Add Default Server.
2. Right click on your SolarWindsOrion database > select New Query. 
3. Use the following query to VIEW Duplicate or Ghost ESX Entry:

   -- 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.
   
   Select HostName, HostID, NodeID, DataCenterID, ClusterID, ManagedObjectID From [dbo].[VIM_Hosts]

   Where HostName = 'Put The Host Name Here'
4. Use the following query to DELETE Duplicate or Ghost ESX Entry:

   -- 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.
   
   Delete HostName, HostID, NodeID, DataCenterID, ClusterID, ManagedObjectID From [dbo].[VIM_Hosts]

   Where HostName = 'Put The Host Name Here'

Using SQL Server Management Studio

1. On your Windows Server, search and login to your SQL Server Management Studio.
2. Expand Databases > right click on your SolarWindsOrion database > select New Query.
3. Use the following query to VIEW Duplicate or Ghost ESX Entry:

   -- 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.
   
   Select HostName, HostID, NodeID, DataCenterID, ClusterID, ManagedObjectID From [dbo].[VIM_Hosts]

   Where HostName = 'Put The Host Name Here'
4. Use the following query to DELETE Duplicate or Ghost ESX Entry:

   -- 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.
   
   Delete HostName, HostID, NodeID, DataCenterID, ClusterID, ManagedObjectID From [dbo].[VIM_Hosts]

   Where HostName = 'Put The Host Name Here'

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment.  You elect to use third party content at your own risk, and you will be solely responsible for the incorporation of the same, if any.