Submit a ticketCall us

Training Class Getting Started with SolarWinds Backup - February 28

This course offers customers an introduction to SolarWinds Backup, focusing on configuring the backup technology, taking backups, data restoration and data security. It is a great primer and will get you up to speed quickly on SolarWinds Backup.
Register for class.

Home > Success Center > Archive > 2018Jan03 - Deletes > Delete stalled NULL VIM hosts values

Delete stalled NULL VIM hosts values

Table of contents
Created by Roie.Exconde, last modified by Gerald.Prado on Jan 03, 2018

Views: 937 Votes: 1 Revisions: 4

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