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 stalled NULL VIM hosts values

Delete stalled NULL VIM hosts values

Table of contents
Created by Roie.Exconde, last modified by MindTouch on Jun 23, 2016

Views: 4 Votes: 1 Revisions: 3

Overview

This article provides steps to delete stalled NULL VIM hosts values that cannot be deleted from the Orion VIM summary page.

Environment

NPM VIM

Steps

Notes: 

  • If your Orion server and SQL server are Virtual Machines, create a snapshot before making any changes.
  • If your Orion server and SQL server are physical machines, create a backup your Orion database (SolarwindsOrion) and NCM database (ConfigMgmt) for NCM 7.2.2 and earlier versions.
    See Creating a backup using SQL Server Management Studio.


1. Open Database Manager from the Start menu.

2. Click Add Default Server.

3. Expand SOLARWINDS_ORION.

4. Expand SolarWindsOrion instance, and then open [dbo].[VIM_Hosts] table.

5. Run the pre-defined query:
SELECT TOP 1000 * FROM [dbo].[VIM_Hosts]

6. Click Enable table Editing.

7. Highlight\select the row/s of the host you want to delete.

8. Right-click on the row and click Delete selected rows.

 

Once done, refresh your Virtualization summary page.

 

 

Last modified
22:07, 22 Jun 2016

Tags

Classifications

Public