How to collect IP Addressing information using SolarWinds Orion NPM

This article describes how to collect IP address information from the devices within Orion. By default, no IP address collection and management is done.

Process Overview

• Login locally to SolarWinds Management Server
• Go to “Universal Device Poller”

• Add the following device pollers:

• After you created one poller, right click on it and select “Web Display”

• Select properties as outlined in the picture below:

• Assign Poller to device

• On the Web Console, go to the Node Details, and you will see the information below.

• Next step of the process is to create a report that will product table with the following columns:
  • Device Name
  • IP Address
  • Subnet Mask
• Login to Orion server through RDP. “Start” -> “All Programs” -> “SolarWinds Orion” -> “Alerting Reporting and Mapping” -> “Report Writer”
• “File” -> “New Report”

SELECT a.NodeID, a.Site_ID, a.Caption, c.RowID, c.Status
FROM dbo.Nodes as a, dbo.CustomPollerAssignment as b, dbo.CustomPollerStatus as c
WHERE a.NodeID = b.NodeID AND b.CustomPollerAssignmentID = c.CustomPollerAssignmentID
AND c.RowID <> c.Status
AND  c.RowID LIKE '%.%.%.%'
ORDER BY a.Site_ID DESC, a.Caption ASC, c.RowID DESC

• Go to Orion Web Console -> Reports -> SQL -> IP Addressing Report