We have a very large Aurba install. I get lots of AP down alerts when we have a switch failure.
I'd like the Thin dependencies automatically generated from the LLDP data
SELECT DISTINCT AP.DisplayName + ' switch dependency' as Name , N.URI as ParentUri, AP.URI as ChildURI
FROM Orion.NodeLldpEntry NL
Inner Join orion.Nodes N
on N.Nodeid=NL.Nodeid and N.Unmanaged=0
inner join Orion.Wireless.AccessPoints AP
on AP.DisplayName=NL.RemoteSystemName
In this way I would expect that if a switch goes down alerts on the APs plugged into it should be suppressed by the alert manager.
[This would add about 11,100 dependencies to our system]