We are now monitoring a 3 node cluster where the 3rd node is Asynchronous so "Data Loss" is its normal state as it is not set for automatic fail-over.
The threshold "MS SQL AlwaysOn - Availability Database Failover Readiness" reports this as a failure
AG-NAME FQ INSTANCE NAME Failover Readiness Data Loss equal to Data Loss (threshold).
How can we set the threshold to only be critical if the value is "Data Loss" when in Synchronous / Automatic fail-over modes.
We want this to trigger if the synchronous nodes evaluate to "Data Loss " so we don't want to remove the threshold , and there are times when which node is asynchronous changes so we don't want to delete the threshold.
Thanks in advance