3 Replies Latest reply on Feb 19, 2017 12:53 PM by orioncrack

    Email webpage - Only Top conversation & Top endpoints Possible?

    praveen.ks

      I'm using the below query for email webpage for high traffic usage.  Could some one help me get only the Top endpoints & conversations in email webpage.  I don't want the other other information's.

       

      ${SQL:SELECT REPLACE(REPLACE(Macro, '$$Password$$', 'xxxx'),'$$User$$', 'yyyy') FROM NetFlowAlertMacros WHERE ID='InWebMailInterfaceDetailsLink'}

       

      Time of Alert: 3/23/2015 1:28 PM

       

      Description: Interface 'Multilink1 · Crkt ID xxxxxxxx on router' received at 83% of its utilization, which triggered this alert.

       

      Link: NetFlow Interface Details - Multilink1 · Crkt ID xxxxxxxxx - router

       

       

       

      Help    Edit 

        Top 5 Protocols  
        Ingress, 3/23/2015 1:23 PM to 3/23/2015 1:28 PM

       

       

      ProtocolIngress
      Bytes
      Egress
      Bytes
      Ingress
      Packets
      Egress
      Packets
      PercentPercent
      (Utilization)
        Protocol 17   UDP  58792093 Visitors58.8 Mbytes-71.36 k-69.49% (50.77%)
        Protocol 6   TCP  25808032 Visitors25.8 Mbytes-24.75 k-30.51% (22.29%)

       

       

       

      Help    Edit 

        Top 5 Applications  
        Ingress, 3/23/2015 1:23 PM to 3/23/2015 1:28 PM

       

       

      ApplicationIngress
      Bytes
      Egress
      Bytes
      Ingress
      Packets
      Egress
      Packets
      PercentPercent
      (Utilization)
        Port 443  http protocol over TLS/SSL (443)    
        Monitored

       

      28569294 Visitors28.6 Mbytes-22.23 k-100% (24.67%)

       

       

      Help    Edit 

        Top 5 Conversations  
        Ingress, 3/23/2015 1:23 PM to 3/23/2015 1:28 PM

       

       

      ConversationIngress
      Bytes
      Egress
      Bytes
      Ingress
      Packets
      Egress
      Packets
      PercentPercent
      (Utilization)
        Conversation  Between x.x.96.133 and x.x.250.230    22987948 Visitors23.0 Mbytes-15.43 k-80.46% (19.85%)
        Conversation  Between x.x.161.106 and x.x.96.133    4790555 Visitors4.8 Mbytes-3.53 k-16.77% (4.14%)
        Conversation  Between x.x.32.135 and x.x.96.113    725629 Visitors725.6 kbytes-3.18 k-2.54% (0.63%)
        Conversation  Between x.x.144.44) and x.x.96.113    65162 Visitors65.2 kbytes-98-0.23% (0.06%)

       

       

       

      Help    Edit 

        Top 5 Endpoints  
        Ingress, 3/23/2015 1:23 PM to 3/23/2015 1:28 PM

       

       

      HostnameIngress
      Bytes
      Egress
      Bytes
      Ingress
      Packets
      Egress
      Packets
      PercentPercent
      (Utilization)
        Endpoint  x.x.96.133    27778503 Visitors27.8 Mbytes-18.95 k-48.62% (23.99%)
        Endpoint  x.x.250.230    22987948 Visitors23.0 Mbytes-15.43 k-40.23% (19.85%)
        Endpoint  x.x.161.106    4790555 Visitors4.8 Mbytes-3.53 k-8.38% (4.14%)
        Endpoint  x.x.96.113    790791 Visitors790.8 kbytes-3.28 k-1.38% (0.68%)
        Endpoint  x.x.32.135    725629 Visitors725.6 kbytes-3.18 k-1.27% (0.63%)

       

       

       

      Help    Edit 

        Top 5 Domains  
        Ingress, 3/23/2015 1:23 PM to 3/23/2015 1:28 PM

       

       

      DomainIngress
      Bytes
      Egress
      Bytes
      Ingress
      Packets
      Egress
      Packets
      PercentPercent
      (Utilization)
        DomainName salesforce.com   salesforce.com  813178 Visitors813.2 kbytes-819-77.5% (0.7%)
        Domain   97895 Visitors97.9 kbytes-275-9.33% (0.08%)
        DomainName force.com   force.com  72809 Visitors72.8 kbytes-134-6.94% (0.06%)
        DomainName 1e100.net   1e100.net  65447 Visitors65.4 kbytes-295-6.24% (0.06%)

       

       

       

      Help    Edit 

        Top 5 Types of Service  
        Ingress, 3/23/2015 1:23 PM to 3/23/2015 1:28 PM

       

       

      Type of ServiceIngress
      Bytes
      Egress
      Bytes
      Ingress
      Packets
      Egress
      Packets
      PercentPercent
      (Utilization)
        Tos   CS0  84513577 Visitors84.5 Mbytes-95.86 k-99.9% (72.98%)
        TosID 16   AF31  78596 Visitors78.6 kbytes-131-0.09% (0.07%)
        TosID 22   EF  7952 Visitors8.0 kbytes-113-0.01% (0.01%)