Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

 

 

 

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: 301 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