Submit a ticketCall us

Get a crash course on Network Monitoring delivered right to your inbox
This free 7-day email course provides a primer to the philosophy, theory, and fundamental concepts involved in IT monitoring. Lessons will explain not only how to perform various monitoring tasks, but why and when you should use them. Sign up now.

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

Overview

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.

Environment

All Orion NTA environments

Steps

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
18:10, 18 Jul 2017

Tags

Classifications

Public