Query to run in the SentryOne database to check your inventory of AlwaysOn Availability Groups

SentryOne_AlwaysOn_Inventory_Check.sql

SELECT SiteName, ReplicaName
	, NumberOfAvailabilityGroups = COUNT(DISTINCT AGName)
	, NumberOfPrimaries = COUNT(DISTINCT PrimaryReplica)
FROM
(
SELECT DISTINCT
	ES.ObjectName AS ReplicaName, S.Name AS SiteName
	, AG.Name AS AGName
	, AG.PrimaryReplica
FROM [SentryOne].[AlwaysOn].[AvailabilityGroup] AS AG
INNER JOIN [SentryOne].[AlwaysOn].[AvailabilityGroupReference] AS AGR ON AGR.GroupID = AG.GroupID
INNER JOIN [SentryOne].[dbo].[EventSourceConnection] AS ES ON AGR.EventSourceConnectionID = ES.ID
LEFT JOIN [SentryOne].[dbo].[Device] AS D ON ES.DeviceID = D.ID
LEFT JOIN [SentryOne].[dbo].[Site] AS S ON D.SiteID = S.ID
) AS q
GROUP BY
	SiteName, ReplicaName
ORDER BY
	SiteName ASC, ReplicaName ASC