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.

SQL Filters

I am new to Orion and, I was hoping for a bit of help with a simple (I hope) SQL filter.

I would like the "Nodes with Problems" report to not display switches with "one or more interfaces down". I can not seem find the correct way to approach this problem. I can remove the switches, but I still want to see when the switch has problems, just not each individual interface that can be up or down as a part of normal operation.

Any help would be appreciated, Thanks.