Skip to main content
jjjjjjjjjj
New Member
March 29, 2018
Question

Report for Specific IP Ranges

  • March 29, 2018
  • 0 replies
  • 1803 views

hi,

I'm using the following dataset and I want to see the traffic (In/Out) between certain IP ranges. I have 9 specific dstip and srcip  ranges. what I have Know is one range

 

select $flex_timescale as hodex, sum( coalesce(sentbyte,0))as traffic_out, sum( coalesce(rcvdbyte,0))as traffic_in from $log where $filter and logid_to_int(logid)not in(4,7,14) and dstip between '192.168.0.0' and '192.168.0.255' group by hodex having sum(coalesce(sentbyte,0)+coalesce(rcvdbyte,0))>0 order by hodex

thank you for your help