All IP's Assigned to Nodes

Version 1

    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