Advanced alerts from with suppresion for multiple devices

cholmes0510

We currently have three devices monitored per site -
router, switch and access point. So for each site we have Store
xxxx Router, Store xxxx Switch and Store xxxx Cloud AP where xxxx is the
restaurant number.
        
I have set up a daily report which lists the restaurante where
for example the AP is down but the router is up by using the SQL:
        
select substring(Nodes.Caption,7,4) as "Restaurant",Nodes.Ip_address as 'IP Address' from Nodes
        where nodes.caption like '%AP%' and (nodes.region ='Restaurant')
        and (nodes.status='2') and substring(Nodes.Caption,7,4) not in (select
        substring(Nodes.Caption,7,4) as "Device" from Nodes
        where nodes.caption like '%router%'
        and (nodes.region ='Restaurant') and (nodes.status='2'))
        order by 1
        
What I would like to do is the same thing for alerts as the
issue occurs, but can find no way of doing this alert suppresion dependent on
another node status.
        
The reason I need this is if the router is down the switch and
AP will therefore be down and I only want to generate one alert and not
three.
        
        Can you assist with this.

KevinMcKloud

Maybe this could help you:

In the Orion Administrator Guide, pague 256, check this out:

http://www.solarwinds.com/support/Orion/docs/OrionAdministratorGuide.pdf

["To configure a dependant node alert suppression"... Suppose that you have just configured an alert that notifies you when nodes on a subnet go down. In this case, the workstations are on a segment of your network on the other side of a particular router. You only want to be alerted to node failures if the router is still operational.]