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/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,362 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