This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Email webpage - Only Top conversation & Top endpoints Possible?

FormerMember
FormerMember

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%)