nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Modifying a field in SQL

ACDII

Hi All, we had done a server move recently and discovered a few of the nodes are using the old poller engine, which no longer exists, with no option to modify it through the browser. Support suggests changing the value under EngineID to match the new one, which is 1, the old one 3, but I have no clue how to do it using SQL 2008 Management Studio. We are using the express version R2.

Find more posts tagged with

Accepted answers

njoylif

if you want to do via sql mgmt studio -> backup your database.

--use this section to see how many rows there are needing updated
use NetPerfMon
select * from Nodes where engineid=3

--use this section to change those rows
use NetPerfMon

update Nodes
set engineid=1
where engineid=3

All comments

pacetti

ACDIII,

You should find the steps you need in the SolarWinds Knowledge Base article, "Changing the IP address of your SolarWinds server" (http://knowledgebase.solarwinds.com/kb/questions/3480/).

HTH,

njoylif

if you want to do via sql mgmt studio -> backup your database.

--use this section to see how many rows there are needing updated
use NetPerfMon
select * from Nodes where engineid=3

--use this section to change those rows
use NetPerfMon

update Nodes
set engineid=1
where engineid=3

ACDII

Bingo, that is what I was looking for. Worked perfectly and found a flaw in our routing too!

njoylif

bonus! glad it worked for you!