Submit a ticketCall us

Solarwinds & Cisco Live! Barcelona
Join us from the 29th of January to the 2nd of February at Cisco Live 2018 in Barcelona, where we will continue to show how monitoring the network with SolarWinds will keep you ahead of the game. At our booth (WEP 1A), we will demonstrate how SolarWinds network solutions can help. As a bonus, we are also hosting a pre-event webinar - Blame the Network, Hybrid IT Edition with our SolarWinds Head Geek™, Patrick Hubbard on January 24th - GMT (UTC+0): 10:00 a.m. to 11:00 a.m. There's still time to RSVP.

Home > Success Center > Network Performance Monitor (NPM) > 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 Rodim Suarez on Aug 26, 2016

Views: 1,072 Votes: 1 Revisions: 3

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.
  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