Submit a ticketCall us

Overcome IP Address Management Challenges in VMware Environments
You rely on your virtual machines, but can you quickly manage their IP addresses? Download the FREE ebook for guidance on how to save time and avoid network disruptions through automated IP address management for vRealize Orchestrator/vRealize Automation. Learn More.

Home > Success Center > Netflow Traffic Analyzer (NTA) > Create a report to view IP addresses associated with any conversation

Create a report to view IP addresses associated with any conversation

Table of contents

Updated July 19, 2017


This article describes how to create a table in a report that lists all IP addresses associated with any conversation involving at least one IP address from a given IP address group.

This can be used as an alternative to a wildcard query which is currently not an option in NTA 4.2.1.


All Orion NTA environments


Note: This process does not include de-duplicating of entries in the table. This serves only as a guide to create the basic data available for further customization.

  1. Add the IP address groups.
  2. Use Database Manager to locate the IPGroupID associated with a recently created IP group. See the Use Database Manager to view the SolarWinds database article for more information.
  3. Use the Name column of the NetFlowIPGroups table to determine the IPGroupID value to be used in the report.
  4. Create a custom table in a report. See the Create a new report article for more information.
  5. Using a dynamic query builder or basic selector, select NetfFlow Flow by IP History in the I want to report on: section.
  6. Create the following statement:
    IPGroupSegmentID > is equal to > [the value of the IPGroupSegmentID in Step 3]
  7. Create the Source IP and Destination IP columns in the Edit Resource section to display the IP addresses of all conversations that match the IPGroupSegmentID in the database.

The table will contain the raw data which can then be de-duplicated or filtered as required.


Last modified