Submit a ticketCall us

Putting Your Logs Where They Belong with the New SolarWinds Log Manager for Orion

The new SolarWinds® Log Manager for Orion® finally puts your log data right where it belongs, in the heart of your Orion console. Gain insight into the performance of your infrastructure by monitoring your logs in a unified console allowing you to see a wealth of information about the health and performance of your network and servers.

Reserve a Seat for Wednesday May 23rd 11am CDT | Reserve a Seat for Tuesday May 22nd 10:30am GMT | Reserve a Seat for Tuesday May 22nd 1pm SGT / 3pm AEST

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