Submit a ticketCall us

whitepaperYour VM Perplexities Called, and They Need You to Read This.

Virtualization can give you enormous flexibility with future workloads and can be a key enabler for other areas, like cloud computing and disaster recovery. So, how can you get a handle on the performance challenges in your virtual environment and manage deployments without erasing the potential upside? Learn the four key areas you need to be focusing on to help deliver a healthy and well-performing data center.

Get your free white paper.

Home > Success Center > IP Address Manager (IPAM) > IPAM - Knowledgebase Articles > Locate duplicate nodes in SolarWinds Database

Locate duplicate nodes in SolarWinds Database

Table of contents

Updated November 29, 2016

Overview

This article provides steps to discover the existence of duplicate nodes in your SolarWinds database.

Environment

All Orion Platform products

Steps

Run the following SQL query against your SolarWinds database, using either SQL Server Management Studio (recommended) or Database Manager:

Note: SolarWindsDatabaseName is the name of your SolarWinds database.

USE SolarWindsDatabaseName
Select IP_address, count(*)
FROM NODES
GROUP BY IP_address
Having COUNT (*)>1

The result will be a list of IP addresses that are each assigned to multiple monitored nodes. Use Node Management in the web console to delete duplicates by IP address.

 

 

 

Last modified

Tags

Classifications

Public