I am trying to create a filter for the nodes with problems resource that is slightly beyond my level of expertise with SQL.
We have many remote sites that generally consist of one router, a few switches, and multiple servers. I’m trying to create a view for the systems support group that shows them all the servers with problems but not show the servers if our connection to the site is down. I have all of the nodes including the servers, switches, and the router tied together with a custom property representing the site. So, I want to create a filter that shows all the servers with problems but not list them if a router with the same custom property is in a down status. Is this possible with a SQL filter on the view? Router Up----->Server Down Visable
Router Down------->Server Down Not Visable
