HI Folks.
We have multiple sites. Each site has a bunch of servers behind a firewall and that firewall behind a router. Currently, if the route goes down, we get Down alerts for each of our servers, which we don't want. Likewise, for the firewall.
SW suggested, we need to manually create a dependency on the firewall and a second dependency on the router.. which is not practical given the volume of servers.
Another option SW suggested was to create an alert for each site (SiteA Servers Down) and have the conditions say "if Server location is SiteA & Server status is down & SiteA-FW status is up & SiteA-Router status is up, then fire the alert". But mentioned we would have to create Custom SQL or SWQL statements for the FW/Router status condition.
Curious what other options people might suggest to achieve this.
OR - what would the custom SQL/SWQL look like to achieve that.
Cheers,
Matt.