Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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: 12 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
18:51, 25 Jan 2017

Tags

Classifications

Public