Submit a ticketCall us

Looking to compare latest NPM features with previous versions of NPM?
The NPM new feature summary offers a comparison of new features and improvements offered with this release.

 

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: 24 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
22:07, 22 Jun 2016

Tags

This page has no custom tags.

Classifications

Public