Hi,
I would like to make an SQL Filter in this view which shows all nodes both the ones which is up and is down at the moment , with a % packetloss of more than 0 last 7 days.
Problem is that I cant see the nodes which is actually UP right now, but has a procentage of packetloss last 7 days.
I now use filter:
Nodes.PercentLoss > 0
Even if I put in
Nodes.PercentLoss > 0 AND Status = 1
There is no nodes showing at all , so seems like it cant show nodes which is up right now but has a certain downtime during the last 7 days.
Thanks in advance!
Andreas, Stockholm.