Submit a ticketCall us

WebinarUpcoming Webinar: Should I Move My Database to the Cloud?

So you’ve been running an on-premises SQL Server® for a while now. Maybe you’ve moved it from bare metal to a VM, and have seen some positive benefits. But, do you want to see more? If you said “YES!”, then this session is for you, as James Serra will review the many benefits that can be gained by moving your on-prem SQL Server to an Azure® VM (IaaS). He’ll also talk about the many hybrid approaches, so you can gradually move to the cloud. If you are interested in cost savings, additional features, ease of use, quick scaling, improved reliability, and ending the days of upgrading hardware, this is the session for you.

Register now.

Home > Success Center > Network Performance Monitor (NPM) > Delete/edit columns in the database

Delete/edit columns in the database

Table of contents
Created by John.Orteza, last modified by MindTouch on Jun 23, 2016

Views: 1,535 Votes: 2 Revisions: 6

Updated June 9, 2016

Overview

This article describes how to delete/edit columns in the SolarWinds SQL Database.

Do this when applicable or when you encounter the following:

  • When mass node updates are needed where the normal procedure takes a great amount of time.
  • Mass update of hostname.

Note: Always backup your SolarWinds database before doing any changes.

Environment

All NPM versions

Steps

  1. Login as Admin in the Orion Server.
  2. Launch Database Manager.
  3. Open the Database used by SolarWinds.
  4. Open the desired Table and look for the column that you want to delete/edit.
    update [table name] set [column]='[value that you want entered]'

 

Some examples:

update NodesData set caption =''

update NodesData set caption ='' where vendor = 'cisco'

update NodesData set IP_Address ='192.168.1.1'

update NodesData set IP_Address ='192.168.1.1' where vendor = 'cisco'

 

More examples:

Deleting Caption column in NodesData table.

 

Deleting Caption Ccolumn of cisco devices in NodesData table.

 

 

 

 

Last modified

Tags

This page has no custom tags.

Classifications

Public