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

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