Submit a ticketCall us

AnnouncementsFace your biggest database issues head-on

Our new eCourse helps you navigate SQL Server performance blocks by teaching you how to recognize and deal with the three DBA Disruptors: Performance Hog, Blame Shifter, and Query Blocker. Register today to learn how to defend your environment and fend off menacing disruptions.

Register for your free eCourse.

Home > Success Center > Network Performance Monitor (NPM) > NPM - Knowledgebase Articles > Create a Top 5 Applications report to get Ingress and Egress information

Create a Top 5 Applications report to get Ingress and Egress information

Table of contents
Created by Michael Almadova, last modified by Aileen de Lara_ret on Oct 04, 2016

Views: 1,409 Votes: 0 Revisions: 6


Steps to create a Top 5 Applications report and get both Ingress and Egress information in the web reports for one specific node.


  • NPM version 11.5 or later
  • NTA version 4 later


  1. Create a new report.
  2. Select Custom Table and click Continue. 
  3. Make sure the Selection Method is Dynamic Query Builder or Specific Objects (static selection). If Static Selection is selected skip steps 4-11 .
  4. Select Advance Selector.
  5. Select I want to report on Netflow History.
  6. Select Where All child conditions must be satisfied (AND).
    Note: This is the default and should not be changed.
  7. Click the green plus button to add simple condition. 
  8. Choose Select Field and ensure that the Orion Object is set to Netflow History.
  9. Select NodeID. 
  10. Set this to - is equal to and add the numbered value for the NodeID.
    Note: The NodeID can be found in the Nodesdata table. 
  11. Add this to the layout and this completes the query. 
  12. When Editing the table layout, add:
    • Caption (the Orion Object should be set to Node to find this value)
    • Source IP
    • Destination IP
    • Ingress Bytes
    • Egress Bytes
    • Total Bytes
  13. Ensure that the Ingress, Egress, and Total columns are expanded by clicking the plus button to configure them. 
  14. Make sure the display setting is in Data Unit Bytes (1000) and that Data Aggregation is set to Sum. Other settings can be left as they are. 
    This is important if you want to see ingress or egress on the same page in order to Sort results.
  15. Select the following:
    Ingress Bytes - Netflow By Conversation History (Descending) for inbound traffic
    Egress Bytes - Netflow By Conversation History (Descending)
    Note: Select only one depending on what you need, but you can always duplicate the Custom Table and change that field to the other direction to have both show up on one report. 
  16. Group Results by Node - Node.
  17. Select Show only top 5 records.
  18. Click Submit to finish the table layout. 
  19. Provide a name for this report and set the time on when the report should run. Then click Next.
    The preview of the report should look something like the example below.
  20. Note: This example shows one table for Ingress and the second table below is for Egress. To get both of the reports, duplicate the first table and then set the duplicate to Egress Bytes - Netflow By Conversation History (Descending) in the table layout.

23. Click Next.

24. Tick the My favorite Reports box if you easily want to find the report. Click Next.

25. Optional: Schedule the report and click Next. 

26. The Summary Page appears. Click Submit. 




Last modified