Network Management

How to delete a row from the database using Database Manager in the SolarWinds Platform

This describes how to delete a row from the SolarWinds Platform database via Database Manager.

First published date

10/30/2018 2:29 PM

Last published date

7/15/2025 9:48 PM

Overview

Before you begin, it is highly recommended to know what row you wish to delete and consider the impact it may have on your SolarWinds environment.

The same steps can also be used when editing a specific column in the database.

Product section

Orion Platform

Resolution

Before you begin, please take a database backup.
RDP to the SolarWinds Platform Server.
Stop all SolarWinds Services on the SolarWinds Platform Service Manager on all SolarWinds Platform servers.
Launch Database Manager (Start > All Programs > SolarWinds Platform > Database Manager.
Select Add Orion Server, this will attach the SolarWinds Platform database.
Expand the table in question.
Right Click and execute the default Select * SQL query and locate the row which contains the host.
Enable Table editing from the top of Database Manager.
Highlight the row in question. Right-click and delete the selected row.
Run the default query again and verify that the row has been deleted.
Start the SolarWinds Services on the SolarWinds Platform Service Manager.

Disclaimer: Please note, any content posted herein is provided as a suggestion or recommendation to you for your internal use. This is not part of the SolarWinds software or documentation that you purchased from SolarWinds, and the information set forth herein may come from third parties. Your organization should internally review and assess to what extent, if any, such custom scripts or recommendations will be incorporated into your environment. You elect to use third-party content at your own risk, and you will be solely responsible for the incorporation of the same if any.