This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

All IP's Assigned to Nodes

Hey Guys,

I recently had one of my customers ask for a report that displays all IP's associated to every device on the network. Figured I would share, there might be a canned report that accomplishes the same task, but for something this simple I just wrote my own query. (Faster than looking for the report).

My customer also wanted to be able to run this on their environment, these are the options I presented.

Solarwinds Database Manager

Login to the Solarwinds NPM server

  • Access the ‘Solarwinds Database Manager’ by following the path below:
  • Start > All Programs > Solarwinds Orion > Advanced Features > Database Manager

This will open the Solarwinds Database Manager

  • From the Database Manager Select 'Add Default Server’
  • Expand your SQL server
  • Expand your database
  • Right click over any table and select 'Query Table'. This will open up a table on the right with a populated query.
  • Delete the existing query and enter the query below

Select nodesdata.Caption AS 'Device Name', NodeIPAddresses.IPAddress

From nodesdata

Join NodeIPAddresses

ON nodesdata.NodeID = NodeIPAddresses.NodeID

Where nodesdata.UnManaged = '0'

  • Select the ‘Execute Query’ option

(Exercise caution on this application; some changes cannot be reverted)

Solarwinds Report Writer

Navigate to the Solarwinds NPM server

  • Access the Solarwinds Report Writer by following the path below:
  • Start > All Programs > Solarwinds Orion > Alerting, Reporting, and Mapping > Report Writer

Once on the Report Writer Select NEW. This will open up an additional prompt.

  • Select ‘Advanced SQL’ and hit OK
  • Classify the report to your liking by customizing the fields in the General Tab
  • Confirm that the 'Make this Report Available from the Orion Website is checked'
  • Navigate to the SQL field and enter the query below in the SQL box.

Select nodesdata.Caption AS 'Device Name', NodeIPAddresses.IPAddress

From nodesdata

Join NodeIPAddresses

ON nodesdata.NodeID = NodeIPAddresses.NodeID

Where nodesdata.UnManaged = '0'

  • The report can be further customized by formatting the output under Field Formatting
  • Once complete save your report by selecting File > Save. The default reports folder will open.
  • You can 'Execute SQL Query' to review the data. Export options are available by selecting File > Menu.

From the Website

(The report must be created in Report Writer for option to work)

  • Access the Solarwinds website with an administrator level account
  • Navigate to the page where the report is to be accessed from
  • Select Customize Page on the top right of that page
  • Add resource Custom List of Reports and select Done
  • Select  Customize this Resource and search for the report created in Report Writer and submit the changes. Once this is complete the report is available for selecting at any time, results will show whenever selected.

Thanks,

David