Submit a ticketCall us

AnnouncementsAre You “Flying Blind?”

When it comes to your complex IT infrastructure, you want to ensure you have a good grasp of what’s going on to avoid any fire drills that result from guesswork. Read our white paper to learn how proactively monitoring your IT environment can help your organization while giving you peace of mind.

Get your free white paper.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Delete a row from the database using Database Manager

Delete a row from the database using Database Manager

Created by Wendell Bazile, last modified by christopher.daly on Nov 16, 2018

Views: 1,825 Votes: 2 Revisions: 4

Overview

This illustrates how to delete a row from a table in the Orion database by leveraging Database Manager. In this instance, there is an ESX host in Orion that is no longer in your environment. This happens when you remove the host from the environment without removing it first in Orion.

Environment

All Orion based products

Resolution

  1. From the Orion server, launch Database Manager (Start > All Programs > Solarwinds orion > Advanced features > Database Manager).
  2. Attach the Orion database and expand the VIM_Hosts table, (or any other table you would like to remove a row from)
  3. Execute the default SQL query and locate the row which contains the host.
  4. Enable Table editing from the top of Database Manager.
  5. Highlight the row in question. Right click and delete the selected row.
  6. Run the default query again and verify that the row has been deleted.

 

Last modified

Tags

Classifications

Public