Submit a ticketCall us

Bridging the ITSM Divide
Integrated help desk and remote support software for faster resolution

Join us on Wednesday, November 29, 2017 at 11 a.m. CT, as we discuss the benefits of effectively integrating your help desk software with remote support solutions to help increase the efficiency of IT administration, improve communication, and decrease mean time to resolution (MTTR) for IT issues of all sizes. This directly impacts end-user satisfaction and your business’ bottom line. Register Now.

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

Tags

Classifications

Public