Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Update all ip address nodes

drfaria

My company will make a big change in your network and i will need to change so many ip address.

How can i change all ip in batch?

Find more posts tagged with

change

setup npm

Accepted answers

d09h

It's not without it's risks, but you can edit data in the database (similar to working with a spreadsheet). If this is out of your comfort zone, you might enlist the support of a DBA. You would definitely want backups.

Edit database fields

You can edit database fields in the Database Manager. We do not recommend changing values directly in the database unless clearly directed to do so by Support or as completed by a DBA. As you make changes and capture data through the Orion Web Console, this data saves safely to the database.

Table editing should only be performed by a database administrator (DBA) or other expert user. Changes made directly in your database can jeopardize the integrity of your data.

SolarWinds recommends that you change database settings and values using the Settings with your Orion Web Console.

1. Start the Database Manager in the SolarWinds Orion > Advanced Features program folder.
2. If the SQL Server hosting your SolarWinds Orion database is not listed in the left pane, add the SQL Server hosting the database. See Add a server to Database Manager.
3. Expand the SQL Server hosting your SolarWinds Orion database in the left pane, and expand the SolarWinds Orion database.

The default database name is SolarWinds Orion.

Right‑click a table, and click Table Details.
Adjust the default SQL query or create a new one, and click Execute.The default SQL query lists the contents of the table.
To edit the data in a table, click Enable Table Editing, and edit the fields in the table.

All comments

d09h

Edit database fields

1. Start the Database Manager in the SolarWinds Orion > Advanced Features program folder.
2. If the SQL Server hosting your SolarWinds Orion database is not listed in the left pane, add the SQL Server hosting the database. See Add a server to Database Manager.
3. Expand the SQL Server hosting your SolarWinds Orion database in the left pane, and expand the SolarWinds Orion database.

The default database name is SolarWinds Orion.

Right‑click a table, and click Table Details.
Adjust the default SQL query or create a new one, and click Execute.The default SQL query lists the contents of the table.
To edit the data in a table, click Enable Table Editing, and edit the fields in the table.

drfaria

Thank you d09h.

If it's the only method, i will ask the DBA team.

I really don't feel comfortable to do this change in DB.

d09h

Using the steps I described, you can craft a statement 'SELECT * FROM WHERE ' With this limited number of rows, make your edits. This can limit the number of places things can go wrong, as you are only touching the rows that match your SELECT statement.

d09h

Always good to have open lines of communication with your DBAs. You may need them to help you make queries, for example. Think of the database editing as a nuclear option, for when the web interface or SDK are not viable options.