I have added a new custom poller ( 188.8.131.52.184.108.40.206.4220.127.116.11.1.13) in cisco load balancer. This gives the operational status of all servers in the load balancing pool. For example if there are 4 servers, then it will give 2,2,2,2 ( 2 means inService).
I want to write an SQL query alert for this, when any of the value is other than 2. I was searching to find the table in which it stores this data. I was not able to find it through DB manager. I can actually run a chart for from the view which gives individual instance value for each server.
Could anybody help me to create an alert when any of the value is other than 2?
I will be able to provide more info, if required.