I have added a new custom poller ( 126.96.36.199.188.8.131.52.4184.108.40.206.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.