Submit a ticketCall us

Webinar: Web Help Desk for HR, Facilities and Accounting Departments
This webinar will focus on use cases for HR, Facilities and Accounting.

Having a unified ticketing and asset management system for all the departments in your company can provide end-users with a seamless experience and make things easier for your IT team. Yet, with different business tasks and objectives, many departments don’t fully understand the capabilities of Web Help Desk and how the software can be customized for effective use in their departments.
Register 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