Submit a ticketCall us

Announcing NCM 7.7
With NCM 7.7, you can examine the rules that make up an access control list for a Cisco ASA device. Then you can apply filters to display only rules that meet the specified criteria, order the rules by line number or by the hit count, and much more.
See new features and improvements.

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