Kindly provide whenever the HA nodes in cisco WLC failover, we need to trigger the alerts in our environment.
You will need to build a SWQL [FYI: it is recommended that you use SWQL and not SQL for scripting in Solarwinds] query around a UnDP.
The UnDP will need to be able to see the OID: 1.3.6.1.4.1.9.9.198888.0.1.12 which should return as 'cLHAPrimaryUnit'. If you do an snmp walk, the current primary unit will return the value 0. Alternatively, once you've built the UnDP, you can use the logic boxes in the "trigger conditions" to build your query and have it be "when not equal to 0".
Recently we had to set up some alerting for exactly this (WLC in HA configuration - failover).
When we looked at it, we determined we could not use UnDP/OID alerting (as the way the WLC's are setup (at least in our environment) is the "share" an IP and the Active pone gets this/responds on this - so when failover we weren't seeing any different states/statuses etc.
The way we did this was to:
1) Ensure Syslog from WLC is sent to SolarWinds (we have ours pointing their Syslog to Kiwi Syslog Server and KSS is forwarding to our Orion Server)
2) Set Syslog Filter in SolarWinds Log Analyzer for the WLC Failover message and tick the related Alert in SolarWinds box (makes the Syslog event a selectable event to define in an Alert Trigger)
3) Create an Alert targeting the WLC Failover syslog message you have just created a filter for.