I am having trouble with getting the delta from my network traffic. So my idea is to calculate the delta and in case I see a large dip(delta) in the graph to report that. I have tried with derivate, difference and non_negative_derivate, but no luck…
@melrose This is just for graphing the network traffic…
SELECT non_negative_derivative(mean(“/interfaces/interface/state/counters/in-octets”), 1s) *8 AS “Ingress Traffic” FROM /interfaces/ WHERE (“device” =~ /^$Routers$/ AND “/interfaces/interface/@name” =~ /^$Interface$/) AND $timeFilter GROUP BY time($__interval), “/interfaces/interface/@name” fill(null)
So can you please let me know what I need to change to just get the delta?
ic” FROM /interfaces/ WHERE (“device” =~ /^Routers/ AND “/interfaces/interface/@name” =~ /^Interface/) AND timeFilter GROUP BY time(__interval), “/interfaces/interface/@name” fill(null)
So can you please let me know what I need to change to just get th
[/quo looks goot to me