The Microsoft SQL Server Database dashboard only shows health for a single Microsoft SQL host in the cluster within SQL Server Instances widget.
VMware Aria Operations 8.x
Aria Operations Management Pack for Microsoft SQL Server 9.x
Due to a current limitation in the management pack, only the health of the server that is currently hosting the cluster role is displayed.
An internal feature request has been raised to have functionality to display health of all Microsoft SQL hosts in a cluster added in a future version of the management pack. Contact your Broadcom account team for additional details.