Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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