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