Hello Team,
Can someone help me on following custom alert creation.
I would like to trigger an alert when the AP status is down/Unknown and while controller status is up.
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Where NodeID in (SELECT a.Name,a.NodeStatus,a.Nodeid,b.name, b.IPaddress, b.controllername, b.status FROM Wireless_Controllers_View a
join Wireless_AccessPoints_View b on (a.nodeid = b.nodeid)
where b.ControllerName like '%RWLC-%' and (status = 0 or status = 2) and NodeStatus = 1 and b.typedescription = 'Thin')