Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Performance Monitor (NPM) > Delete ESX Ghost Entry

Delete ESX Ghost Entry

Table of contents
Created by Jousseff Jaranilla, last modified by Rodim Suarez on Jan 26, 2017

Views: 325 Votes: 1 Revisions: 7

Updated January 26, 2017

Overview

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

Environment

  • NPM 11.5.2 and later
  • Database Manager
  • SQL Server (Management Studio)

Steps

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:
    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:
    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:
    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:
    Delete HostName, HostID, NodeID, DataCenterID, ClusterID, ManagedObjectID From [dbo].[VIM_Hosts]
    Where HostName = 'Put The Host Name Here'

 

Last modified

Tags

Classifications

Public