Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register Now.

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: 222 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
19:04, 25 Aug 2016

Tags

Classifications

Public