Create a custom report for IP address groups in NTA
- Click Reports > All Reports.
- Click Manage Reports.
- Click Create New Report.
- Click Custom Table, and then click Select and Continue.
- Define what objects should be in the report. We want to report on collected traffic connected with IP address groups. IP addresses included in a group have a property that gives the IP address group.
- Under Selection Method, select Dynamic Query Builder.
- Click Advanced Selector.
- In the I Want to Report On list, select NetFlow Flow by IP History.
- Click Select Field.
- On the Add Column menu, under Available Columns, click NetFlow IP Address Group.
- Under Database Column name, click IP Address Group Name.
- Click Add Column.
- On the Add Content menu, go to the IP Address Group name property list and select Is Not Empty.
- Enter a Selection Name.
- Click Add to Layout.
- Define what columns you want to see in the report, how the items should be sorted, how many items you want to see, how the items should be grouped, and details for individual columns:
- Click Add Column.
-
Add appropriate columns.
- Add the IP Address Group Name column:
- Select NetFlow Flow by IP History in the Orion Object list.
- Under Available Columns, click NetFlow IP Address Group.
- Under Database Column Name, select IP Address Group Name.
- Add the Bytes column:
- Select NetFlow Flow by IP History in the Orion Object list.
- Under Available Columns, click NetFlow Flows by IP History.
- Under Database Column Name, select Bytes.
- Add the Node Name column:
- Select Node in the Orion Object list.
- Under Available Columns, click Node.
- Under Database Column Name, select Node Name.
- Click Add Column.
- Add the IP Address Group Name column:
-
Define table sorting.
- Under Sort Results By, select Bytes - NetFlow Flow by IP History.
- Define the sorting direction as Ascending.
-
Specify units and aggregation of bytes.
- Under the Bytes column, click Advanced.
- In the Add Display Settings list, select Data Unit.
- In the Units of Measurements list, select Bytes (1000). This defines the units shown on the report.
- In the Units in My Database list, select B.
- In the Data Aggregation list, select Sum.
- Use the Filter Number of Results section to limit the number of items shown by the report.
- Use the Group Results By list to set how individual items are grouped in the report.
- Click Preview Resource, and then click OK.
- Click Submit.
- Add the report to your SolarWinds Platform reports:
- Define the report layout:
- Enter a Title and Subtitle. You can also change the logo, page layout, and footer.
- Under Content, in the From list, select Last 24 Hours.
- Click Next.
- Check the preview, and click Next.
- Define the report properties, and click Next.
- If you want to create the report regularly, schedule the report, and click Next.
- Review the summary, and click Submit.
- Define the report layout: