Create a custom report for EF type of service in NTA
SolarWinds NPM 10.7 or later is required.
- 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 traffic using a specified type of service, so we need to specify that we are interested in NetFlow History objects whose type of service is EF.
- Under Selection Method, select Dynamic Query Builder.
- Click Advanced Selector.
- In the I Want to Report On list, select NetFlow Flow History.
- Click Select Field.
- On the Add Column menu, under Available Columns, click NetFlow Type of Service.
- Under Database Column Name, click ToS Name.
- Click Add Column.
- On the Add Content menu, go to the ToS Name property list and select Is Equal To.
- Type
EF
in the last field on that line. - 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, or details for individual columns:
- Click Add Column.
-
Add appropriate columns.
- Add the Node Name column:
- Select Node in the Orion Object list.
- Under Available Columns, click Node.
- Under Database Column Name, select Node Name.
- Add the Ingress Interface Name column:
- Select Interface in the Orion Object list.
- Under Available Columns, click Ingress Interface.
- Under Database Column Name, select Interface Name.
- Add the ToS Name column:
- Select NetFlow Flow History in the Orion Object list.
- Under Available Columns, click NetFlow Type of Service.
- Under Database Column Name, select ToS Name.
- Add the Bytes column:
- Select NetFlow Flow History in the Orion Object list.
- Under Available Columns, click NetFlow Flows History.
- Under Database Column Name, select Bytes.
- Click Add Column.
- Add the Node Name column:
-
Define table sorting.
- Under Sort Results By, select Bytes - NetFlow Flow History.
- Define the sorting direction as Descending.
-
Specify units and aggregation for 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: