Apparently solarwinds does not do quite enough for generating an alert when an access point(AP) goes down. At our location we have over 5000 APs. I would like to generate an alert as follows probably by writing a script in some language preferably on a solarwinds server but possibility outside of solarwinds. This script can be written in any of a bunch of languages C & Java I would prefer ro avoid. (PHP Perl OORexx are a few I like).
1) Send an email alert once a day for all devices that that are down (and indicate if the switch it is connected to is down also).
2) Send an action alert every 10 minutes if a bunch (say 5 or more) of access points go down in one period NOT due to a switch going down) (don't repeat the alert for the same devices unless they are bouncing)
Solarwinds monitors the wireless controllers and knows when the device goes down and also knows when the switch goes down BUT it does not gather the information about what switch that AP is connected to.
There is a OID 1.3.6.1.4.1.9.9.623.1.3.1.1 that contains a table of all the AP's and switches it is connected too (if CDP is enabled) and the port it is connected to. (and speed and a few other items not needed).
This can be gathered from the controllers and a files saved say once a day. (it makes no sense gathering this continuously).
My question is what is the best way to accomplish this task.